Hi,
On Sun, Sep 24, 2017 at 7:46 AM, Baruch Burstein <bmburst...@gmail.com> wrote:
> SQLite version 3.20.1 2017-08-24 16:21:36
> sqlite> create table T(C);
> sqlite> insert into T values("test 1");
> sqlite> select last_insert_rowid();
> 1
> sqlite> begin;
> sqlite> insert into T values("test 2");
> sqlite> select last_insert_rowid();
> 2
> sqlite> rollback;
> sqlite> select last_insert_rowid();
> 2
>
> In other words, the rollback doesn't roll back the rowid.
I think it is as rowid is auto-increment.
There was a recent thread about that. Check the archive for details.
Thank you.
>
> --
> ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
