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
[email protected]
_______________________________________________
sqlite-announce mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-announce
