IF NOT EXISTS BB_URI_HEADREVS(key TEXT
PRIMARY KEY NOT NULL, value TEXT); COMMIT;
BEGIN TRANSACTION; SELECT COUNT(key) FROM BB_URI_HEADREVS;
COMMIT; BEGIN TRANSACTION; DELETE FROM BB_URI_HEADREVS; COMMIT;
Thanks all for your time,
--
Joshua Watt
___
believe this is because walCheckpoint() triggers a call to
walRestartHdr() if the mode is SQLITE_CHEKPOINT_TRUNCATE. Once
walCheckpoint() returns, sqlite3WalCheckpoint() attempts to extract the
values from the already restarted wal header.
Has anyone else expir
On Wed, 2018-02-14 at 08:13 -0600, Joshua Watt wrote:
> Hello,
>
> I observed the following behavior when using the wal_checkpoint
> PRAGMA
> in TRUNCATE mode:
>
> SQLite version 3.22.0 2018-01-22 18:45:57
> Enter ".help" for usage hints.
> Connected to
3 matches
Mail list logo