#1104569 .recover command does not work

Package:
sqlite3
Source:
sqlite3
Description:
Command line interface for SQLite 3
Submitter:
Peter Horvath
Date:
2025-05-02 08:48:01 UTC
Severity:
normal
#1104569#5
Date:
2025-05-02 08:45:24 UTC
From:
To:
$ 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