Package: sqlite3
Version: 3.46.1-3

$ sqlite3
SQLite version 3.46.1 2024-08-13 09:16:08
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .recover
BEGIN;
PRAGMA writable_schema = on;
PRAGMA encoding = 'UTF-8';
PRAGMA page_size = '4096';
PRAGMA auto_vacuum = '0';
PRAGMA user_version = '0';
PRAGMA application_id = '0';
sql error: no such table: sqlite_dbpage (1)

With vanilla compiled sqlite3, it works. #define -s in src/dbpage.c say,
most likely we need a -DSQLITE_ENABLE_DBPAGE_VTAB in debian/rules.

Good work!

Peter Horvath

Reply via email to