[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 seems to be that the tables have been created using the following 
> SQL:
> CREATE TABLE DeviceEndpoint (
>     ID  INTEGER  NOT NULL  PRIMARY KEY  AUTOINCREMENT,
>     ...
> );
>
> It seems the new version does not like the "NOT NULL" be placed between 
> "INTEGER" and "PRIMARY KEY"

sqlite> CREATE TABLE DeviceEndpoint (
   ...> ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
   ...> [...]
   ...> );
sqlite>

Might this error come from another table?  Are you using AUTOINCREMENT 
elsewhere?


Regards,
Clemens