| Ticket Hash: | 13137dccf36902cdd4e20c11d857c7ad7f5d8777 | ||
| Title: | FTS3 and last_insert_rowid() | ||
| Status: | Closed | Type: | Feature_Request |
| Severity: | Minor | Priority: | Immediate |
| Subsystem: | Extensions | Resolution: | Rejected |
| Last Modified: |
2014-03-11 13:20:19 11.32 years ago |
Created: |
2009-12-01 09:41:57 15.60 years ago |
| Version Found In: | 3.6.21 | ||
| Description: | ||||
The following session illustrates the problem.
SQLite version 3.6.21 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE VIRTUAL TABLE t1 USING fts3; sqlite> INSERT INTO t1(rowid, content) VALUES(123, 'some text'); sqlite> SELECT last_insert_rowid(); 1 sqlite> SELECT rowid FROM t1; 123 FTS3 writes data to the database from with the virtual table xSync() callback. This is setting the value returned by last_insert_rowid(). dan added on 2010-03-25 04:43:22: | ||||