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

Re: [sqlite] WAL Checkpoint Blocking Behavior

2017-02-26 Thread Clemens Ladisch
Matt Fichman wrote: > I plan to disable WAL autocheckpoints and manually run permissive WAL > checkpoints on a second thread (as hinted at by the docs). > > If I do this, can a WAL checkpoint on the checkpoint thread still block or > significantly delay queries/updates from the main thread? The

[sqlite] WAL Checkpoint Blocking Behavior

2017-02-26 Thread Matt Fichman
Hi all, I'm trying to use SQLite in an asynchronous application that requires low/predictable latency access to the database. To achieve this is, I plan to disable WAL autocheckpoints and manually run permissive WAL checkpoints on a second thread (as hinted at by the docs). If I do this, can a

[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