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