Hi Clemens,?
> Gesendet:?Montag, 18. April 2016 um 16:07 Uhr
> Von:?"Clemens Ladisch" <clemens at ladisch.de>
> 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?
Sorry, I have rechecked this. The problem is not the order of the NOT NULL
clause, but the "[" and "]" in this syntax:
CREATE TABLE Customer (
[ID] [INTEGER] NOT NULL PRIMARY KEY AUTOINCREMENT
);
We have used this syntax to create the tables, which worked in SQLite up to
3.9.2. However, since 3.12.1 I'm getting the error with the autoincrement when
opening an existing DB with SQLite 3.12.1.
Thanks!
Regards,
Konstantin Prei?er
