Is this really a bug? I at least wouldn't expect last_insert_rowid to be constant if the database gets modified.
/eno On 04.04.2011, at 13:28, Alexey Pechnikov wrote: > $ sqlite3 > SQLite version 3.7.6 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> CREATE VIRTUAL TABLE fts USING fts4(a,TOKENIZE icu russian); > sqlite> select last_insert_rowid(); > 0 > sqlite> insert into fts(a) values ('test'); > sqlite> insert into fts(a) values ('test'); > sqlite> select last_insert_rowid(); > 2 > sqlite> delete from fts where rowid=2; > sqlite> select last_insert_rowid(); > 3 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users