Package: sqlite3 Version: 3.40.1-2+deb12u1 Severity: normal Dear Maintainer,
sqlite3 ".dbinfo" command works fine in bullseye, fails in bookworm and trixie, upstream suggests [1] to enable SQLITE_ENABLE_DBPAGE_VTAB [2] compile option to fix this. Reproducer: sqlite3 ':memory:' 'CREATE TABLE contacts (id INTEGER PRIMARY KEY);' '.dbinfo' Works fine in bullseye: root@debian-4gb-hel1-6:~# lsb_release -d Description: Debian GNU/Linux 11 (bullseye) root@debian-4gb-hel1-6:~# sqlite3 --version 3.34.1 2021-01-20 14:10:07 10e20c0b43500cfb9bbc0eaa061c57514f715d87238f4d835880cd846b9ealt1 root@debian-4gb-hel1-6:~# sqlite3 ':memory:' 'CREATE TABLE contacts (id INTEGER PRIMARY KEY);' '.dbinfo' database page size: 4096 [...] data version 2 root@debian-4gb-hel1-6:~# Fails in bookworm and trixie: root@debian-4gb-hel1-6:~# lsb_release -d No LSB modules are available. Description: Debian GNU/Linux 12 (bookworm) root@debian-4gb-hel1-6:~# sqlite3 --version 3.40.1 2022-12-28 14:03:47 df5c253c0b3dd24916e4ec7cf77d3db5294cc9fd45ae7b9c5e82ad8197f3alt1 root@debian-4gb-hel1-6:~# sqlite3 ':memory:' 'CREATE TABLE contacts (id INTEGER PRIMARY KEY);' '.dbinfo' error: no such table: sqlite_dbpage root@debian-4gb-hel1-6:~# root@debian-4gb-hel1-4:~# lsb_release -d Description: Debian GNU/Linux trixie/sid root@debian-4gb-hel1-4:~# sqlite3 --version 3.46.1 2024-08-13 09:16:08 c9c2ab54ba1f5f46360f1b4f35d849cd3f080e6fc2b6c60e91b16c63f69aalt1 (64-bit) root@debian-4gb-hel1-4:~# sqlite3 ':memory:' 'CREATE TABLE contacts (id INTEGER PRIMARY KEY);' '.dbinfo' error: no such table: sqlite_dbpage root@debian-4gb-hel1-4:~# Thank you, Lukas Tribus [1] https://sqlite.org/forum/forumpost/76011ac1f04d2c16 [2] https://www.sqlite.org/compile.html -- System Information: Debian Release: 12.9 APT prefers stable-updates APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 6.1.0-31-amd64 (SMP w/2 CPU threads; PREEMPT) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE not set Shell: /bin/sh linked to /usr/bin/dash Init: systemd (via /run/systemd/system) Versions of packages sqlite3 depends on: ii libc6 2.36-9+deb12u9 ii libreadline8 8.2-1.3 ii libsqlite3-0 3.40.1-2+deb12u1 ii zlib1g 1:1.2.13.dfsg-1 sqlite3 recommends no packages. Versions of packages sqlite3 suggests: pn sqlite3-doc <none> -- no debconf information
