On 2018/03/21 11:13 AM, Paul Sanderson wrote:
Actually it is totally different Chris
Indeed, and thank you for highlighting this.
I'm so used to putting down CREATE TABLE t (id INTEGER PRIMARY KEY, f2,
f3,... ) and seeing the id increment automatically when needed, I lost
sight of the fact that this HAS to be the rowid alias to work (i.e.
INTEGER and not INT).
This little fact probably lends slightly more weight to Peter's request
for a way to tell INTEGER PRIMARY KEY apart from INT PRIMARY KEY in a
way that doesn't require a schema parse.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users