Re: [sqlite] Autoincrement with rollback

Hi Darren, Thanks for explaining the internals. I already assumed by my 2 small experiments that this was the case but it's nice to have it confirmed. With kind regards, Koen 2014-11-11 12:05 GMT+01:00 Darren Duncan <dar...@darrenduncan.net>: > On 2014-11-11 2:41 AM, Koen Van E

Re: [sqlite] Autoincrement with rollback

he database back to the > state it was in before the transaction started. So everything should be > just as if no inserts (or deletes or anything else)had happened, including > any changes to autoincrement values. > > Regards > > Andy Ling > > __

Re: [sqlite] Autoincrement with rollback

Koen 2014-11-11 10:35 GMT+01:00 Clemens Ladisch <clem...@ladisch.de>: > Koen Van Exem wrote: > > Is it a bug or feature that the autoincrement > > value is being reused when a rollback is issued? > > > > The documentation on https://www.sqlite.org/autoinc.html is

[sqlite] Autoincrement with rollback

WIDs from previously deleted rows. In bullet 1 it says that it takes a value higher than the largest ROWID. In bullet 2 it says it prevents reuse of ROWIDs from previously deleted rows. Can someone please clarify? Thanks, Koen -- Koen Van Exem +32 2335 2335 k...