HeidiSQL 12.10.0.7023 - SQLite Primary Key AutoIncrement not properly made

onering20's profile image onering20 posted 1 year ago in General Permalink

When trying to create a table with an auto increment primary key the create code does not form correctly

create code from HeidiSQL:

CREATE TABLE "test5" ( "Column 1" INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY ("Column 1") );

The Query that works:

CREATE TABLE "test5" ( "Column 1" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, );

ansgar's profile image ansgar posted 1 year ago Permalink

Please reports bugs in the tracker. There is already one that matches your description: issue #1606

Please login to leave a reply, or register at first.