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
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)