SQLite version 3.12.2 is now available on the SQLite website

     https://www.sqlite.org/

Version 3.12.2 is an emergency patch release to fix a backwards compatibility 
bug.  Versions 3.12.0 and 3.12.1 of SQLite are unable to read certain (obscure) 
legacy database files and might generate database files that are unreadable by 
any other version of SQLite.

The problem only comes up for database files where one or more tables contains 
a column definition like this:

      "INTEGER" PRIMARY KEY

Specifically, the problem only occurs when the INTEGER keyword in an INTEGER 
PRIMARY KEY is quoted.  As long as you do not quote the INTEGER keyword, SQLite 
versions 3.12.0 and 3.12.1 work fine.

The SQLite developers had never before thought to try to quote datatype 
keywords.  So this is not something that was previously documented or tested, 
which is how it managed to slip past our quality processes.

Three other minor problems are also fixed in the patch release.  Those other 
problems would normally have waited until the next scheduled release, but are 
included in this patch for completeness.

--
D. Richard Hipp
d...@sqlite.org



_______________________________________________
sqlite-announce mailing list
sqlite-announce@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-announce

Reply via email to