Hi All, We are using SQLite 3.7.16.1 in our product which has been released to market sometime back. We have been analysing releases of SQLite from 3.7.16 to 3.19.2 to see if we need to upgrade the SQLite for the software that is already deployed in the field. For this purpose we use release history of SQLite, go through the bug fixes done and check if we need to upgrade SQLite depending on the bug fix done. While doing this analysis we came across this fix: "Use the correct affinity for columns of automatic indexes. Ticket 7ffd1ca1d2ad4ec(https://www.sqlite.org/src/info/7ffd1ca1d2ad4ec)." which was fixed in 3.17.0 The description of the bug fix is not detailed and hence we don't know if we need to upgrade SQLite version. We use simple queries like 'select * from abc where col1=123 and col2=456'. We dont use any JOINs, VIEWs, nested queries. The tables we use do have primary keys and foreign keys. Please let us know in which cases the bug will impact and whether we may be affected.
Thank you, Mohan _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users