To whom it may concern,
Whilst using an ODBC driver for SQLite acquired from: http://www.ch-werner.de/sqliteodbc/ I came across a potential bug in SQLite. I have an application running VB.NET on a Windows 7 32-bit machine and have installed the sqliteodbc.exe from the website above. I am using a query to check a date field between a range of dates, the exact query being: SELECT ind.CUSTOMERU, ind.XTRANU, ind.DDATE, SUM(ind.DAMOUNT) as REVENUE, MIN(inc.SURNAME) as CNAME FROM INV_DETAIL ind inner JOIN CUSTOMER inc ON ind.CUSTOMERU=inc.UNIQ WHERE ind.DDATE BETWEEN '2018-02-01' AND '2018-02-28' AND ind.DTYPE='3' AND ind.DAMOUNT<0 AND ind.SUBCONTRU<>'666' AND ind.SUBCONTRU<>'555' GROUP BY ind.CUSTOMERU, ind.XTRANU ORDER BY ind.CUSTOMERU, ind.XTRANU; When running this with the ODBC driver it fails to return all the appropriate record in the range. I tried the exact same query in a DB Browser for Sqlite and it recovers 127 records only. I have run the same query using ODBC and Access (office 2003) and it recovers 138 records. Doing a manual filter of the records from the INV_DETAIL table I can extract 138 records!! The records apparently omitted by SQLite are one with DDATE equal to the start date of 2018-02-01. If I make the start date one day earlier the SQLite query returns 138 records!! I have attached a spreadsheet with the data from the report I am generating and with the INV_DETAIL data for the whole month of Feb 2018. Regards Bob Maxwell _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
