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

[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
>
> The problem is ... the "[" and "]" in this syntax:
> CREATE TABLE Customer (
>     [ID] [INTEGER]  NOT NULL  PRIMARY KEY  AUTOINCREMENT
> );

Quoting an indentifier prevents the database from interpreting it as a keyword.

Arguably, the old SQLite version did this wrong in this case.


Regards,
Clemens