Re: [sqlite] Bug: Column Constraint

Not a bug. See the 4th paragraph at http://www.sqlite.org/lang_createtable.html#rowid On Thu, Jul 22, 2010 at 8:03 AM, sanjiv wrote: > When I use the following command string: >"CREATE TABLE tbl1 (Id INT CONSTRAINT PK_Id PRIMARY KEY > AUTOINCREMENT NOT NULL ,Name VARCHAR(20) )" > I get the

[sqlite] Bug: Column Constraint

When I use the following command string: "CREATE TABLE tbl1 (Id INT CONSTRAINT PK_Id PRIMARY KEY AUTOINCREMENT NOT NULL ,Name VARCHAR(20) )" I get the following SQLite exception: "AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY" wherease no exception is thrown if INT in the comman