SQLite version 3.14.0 2016-07-26 15:17:14 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> CREATE TABLE foo (bar INTEGER PRIMARY KEY AUTOINCREMENT); sqlite> INSERT INTO foo (bar) VALUES(1234); sqlite> SELECT * FROM foo; 1234 sqlite> UPDATE foo SET bar=5678; sqlite> SELECT * FROM foo; 5678 sqlite> DELETE FROM foo; sqlite> SELECT * FROM foo; sqlite> INSERT INTO foo DEFAULT VALUES; sqlite> SELECT * FROM foo; 1235 sqlite>
Suggests that in 3.14.0 the autoincrement number isn't changed by UPDATE. It guess it comes down to what one wants from "INTEGER PRIMARY KEY AUTOINCREMENT". If the requirement is only-ever-increasing then this is a bug. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users