I read that - but my point was more that some people seem to think that an int primary key can be auto incrementing, it can't.
SQLite version 3.18.0 2017-03-28 18:48:43 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> create table test (id integer primary key autoincrement); sqlite> create table test2 (id int primary key autoincrement); Error: AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY sqlite> Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 20 March 2018 at 08:48, R Smith <ryansmit...@gmail.com> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users