[sqlite] SQLite 3.12.1 reports "database corruption" with existing databases created with SQLite 3.9.2

[Sorry, I sent an HTML email which doesn't seem do be allowed by the mailing list. I'm sending the message again as plain text] Hi, we are using SQLite in a C# (.Net 4.6, x86 and x64) Application on Windows 10/7 using the System.Data.Sqlite wrapper from https://system.data.sqlite.org. We use th

[sqlite] SQLite 3.12.1 reports "database corruption" with existing databases created with SQLite 3.9.2

Hi Clemens,? > Gesendet:?Montag, 18. April 2016 um 16:07 Uhr > Von:?"Clemens Ladisch" > t18970237136 at web.de wrote: > > after updating to 1.0.100.0 which uses SQLite 3.12.1, we are getting the > > following error > > > > SQLite error (1): AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY

[sqlite] SQLite 3.12.1 reports "database corruption" with existing databases created with SQLite 3.9.2

Hi, Gesendet:?Montag, 18. April 2016 um 19:38 Uhr Von:?"Richard Hipp" > On 4/18/16, Clemens Ladisch wrote: > > > > Quoting an indentifier prevents the database from interpreting it as a > > keyword. > > > > Arguably, the old SQLite version did this wrong in this case. > > Backwards compatibilit