So, I’ve been playing around with liquibase some more and if I define a column with type integer and primary key and set the autoincrement value to true, the generated sql is incorrect CREATE TABLE log (logid INTEGER CONSTRAINT logid PRIMARY KEY AUTOINCREMENT AUTOINCREMENT NOT NULL, date INTEGE…

Sqlite3 - Integer primary key with auto increment

sproket March 29, 2011, 7:28am 5

Nathan, could you please mark SQLite as PARTIAL Support on your web site? We waste time with this thinking SQLite is supported and obviously it’s not.

Topic		Replies	Views
autoIncrement for primaryKey of type int in sqlite generates incorrect sql statements General Discussion	0	383	March 31, 2011
Autoincrement and insert of id General Discussion	1	2843	December 22, 2010
auto inkrement for id General Discussion	2	532	November 10, 2011
Derby AutoIncrement General Discussion	3	626	May 12, 2010
Formatted sql identity auto increment syntax?	1	1908	April 21, 2022

Sqlite3 - Integer primary key with auto increment

Related topics