Hello,
I have found a regression in SQLite 3.17.0. In the following SQL statements:
CREATE VIRTUAL TABLE t1 USING FTS5(content);
INSERT INTO t1(content) VALUES ('some text');
SELECT last_insert_rowid(); // 10 (wrong)
SELECT rowid FROM t1; // 1
The expected value of the the SQL function last_insert_rowid() function is 1,
not 10. Same for the C function sqlite3_last_insert_rowid().
This bug was not present in 3.16.2.
This bug is very similar to http://www.sqlite.org/src/tktview?name=13137dccf3,
which affected FTS3.
Cheers,
Gwendal Roué
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
