On 2018/03/20 10:24 AM, Paul Sanderson wrote:
Autoincrement can ONLY be used with an integer primary key
I think Peter's shouting is more about the inability to distinguish via SQL or Pragma between an INTEGER PRIMARY KEY and an INT PRIMARY KEY, both of which are of course integer and can be auto-incrementing, but only one of which is an alias for rowid.
_______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users