On 8/31/17, Noah Simon <noahs2...@gmail.com> wrote: > Hello, > While using the sqlite3 SQL shell from macOS Sierra Terminal, a bug (I > think) occurred. > > Version number: > sqlite> .version > SQLite 3.13.0 2016-05-18 10:57:30 fc49f556e48970561d7ab6a2f24fdd7d9eb81ff2 > > What happened was I created a table with an autoincremented primary key. > After creating a row of values, I deleted that row. I then created two more > rows, but their IDs were 2 and 3, not 1 and 2. The expected behavior was > that when I removed the most recent row in a table, the autoincrement would > go back.
Your expectations are incorrect. See https://www.sqlite.org/autoinc.html for complete documentation of AUTOINCREMENT in SQLite. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
