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
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
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
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
4 matches
Mail list logo