Re: [sqlite] last_insert_rowid() returns wrong value after insert in a fts5 virtual table.

2017-02-27 Thread Dan Kennedy
On 02/28/2017 12:15 AM, Cezary H. Noweta wrote: Hello, On 2017-02-27 11:41, Dan Kennedy wrote: CREATE VIRTUAL TABLE f USING fts3(x); BEGIN; INSERT INTO f VALUES('one'); INSERT INTO f VALUES('two'); INSERT INTO f VALUES('three'); INSERT INTO f VALUES('four'); COMMIT;

Re: [sqlite] last_insert_rowid() returns wrong value after insert in a fts5 virtual table.

2017-02-27 Thread Cezary H. Noweta
Hello, On 2017-02-27 11:41, Dan Kennedy wrote: CREATE VIRTUAL TABLE f USING fts3(x); BEGIN; INSERT INTO f VALUES('one'); INSERT INTO f VALUES('two'); INSERT INTO f VALUES('three'); INSERT INTO f VALUES('four'); COMMIT; INSERT INTO f VALUES('five'); SELECT

Re: [sqlite] last_insert_rowid() returns wrong value after insert in a fts5 virtual table.

2017-02-27 Thread Dan Kennedy
On 02/27/2017 05:03 AM, Cezary H. Noweta wrote: Hello, While working on the Perl DBD:SQLite driver, I found the following bug in sqlite : the last_insert_rowid() method (or SQL function) returns the constant value 10 after any insert into a fts5 virtual table. This bug is new in fts5 :

Re: [sqlite] last_insert_rowid() returns wrong value after insert in a fts5 virtual table.

2017-02-26 Thread Cezary H. Noweta
Hello, While working on the Perl DBD:SQLite driver, I found the following bug in sqlite : the last_insert_rowid() method (or SQL function) returns the constant value 10 after any insert into a fts5 virtual table. This bug is new in fts5 : previous versions fts4 and fts3 returned the correct

[sqlite] last_insert_rowid() returns wrong value after insert in a fts5 virtual table.

2017-02-26 Thread Laurent Dami
Hi, While working on the Perl DBD:SQLite driver, I found the following bug in sqlite : the last_insert_rowid() method (or SQL function) returns the constant value 10 after any insert into a fts5 virtual table. This bug is new in fts5 : previous versions fts4 and fts3 returned the correct