David Baird wrote: > # INSERT INTO "StringIntern" VALUES(5,'c'); <-- undesired behavior > # INSERT INTO "StringIntern" VALUES(3,'c'); <-- desired behavior
Works for me. Are you sure you actually executed this actual code? <http://www.sqlite.org/autoinc.html> guarantees that a newly inserted row uses the next available rowid value, if you have an INTEGER PRIMARY KEY column. You might get the undesired behaviour only with an INTEGER PRIMARY KEY AUTOINCREMENT column. Regards, Clemens