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 :
> On 2014-11-11 2:41 AM, Koen Van Exem wrote:
>
>>
abase 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
>
>
this possible?
Thanks,
Koen
2014-11-11 10:35 GMT+01:00 Clemens Ladisch :
> 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
the reuse of ROWIDs 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 Exe
4 matches
Mail list logo