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. Is this a misunderstanding on my part, or should this be fixed? Let me know if you need reproducing steps. Thank you, Noah Simon _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
