We tested the work of LiteDAC 3.1.3 according to your description and found no problems. Please check the work of your query using SQLite command-line tools, available at the project website:
http://www.sqlite.org/download.html In case of getting the correct result, please compose and send us a small test project, in which the issue occurs. In addition, we will need the SQLite database file used in this sample. For this, use the e-support form (
https://www.devart.com the "Support"\"Request Support" menu)