Your message dated Mon, 26 May 2025 21:36:17 +0000
with message-id <e1ujfux-00ak33...@fasolo.debian.org>
and subject line Bug#1099542: fixed in sqlite3 3.46.1-5
has caused the Debian Bug report #1099542,
regarding Enable SQLITE_DBPAGE extension
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
1099542: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1099542
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
Source: sqlite3
Source-Version: 3.46.1-5
Done: Laszlo Boszormenyi (GCS) <g...@debian.org>
We believe that the bug you reported is fixed in the latest version of
sqlite3, which is due to be installed in the Debian FTP archive.
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to 1099...@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Laszlo Boszormenyi (GCS) <g...@debian.org> (supplier of updated sqlite3 package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmas...@ftp-master.debian.org)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Format: 1.8
Date: Sat, 24 May 2025 15:36:17 +0200
Source: sqlite3
Architecture: source
Version: 3.46.1-5
Distribution: unstable
Urgency: medium
Maintainer: Laszlo Boszormenyi (GCS) <g...@debian.org>
Changed-By: Laszlo Boszormenyi (GCS) <g...@debian.org>
Closes: 1099542
Changes:
sqlite3 (3.46.1-5) unstable; urgency=medium
.
* Backport upstream fix for a bug in the NOT NULL/IS NULL optimization that
can cause invalid data to be used for a column if that column has a CHECK
constraint that includes the NOT NULL or IS NULL operator.
* Enable the SQLITE_DBPAGE extension (closes: #1099542).
* Update symbols file.
Checksums-Sha1:
a528ada87b19df62f98c164c1a6120c76a59b464 2632 sqlite3_3.46.1-5.dsc
4d39a1dd3c23d7df7af1997cb353dd7140c374db 33908 sqlite3_3.46.1-5.debian.tar.xz
Checksums-Sha256:
53c38cd39763e5f01833f943542e2b1f670681107e86bda852da6275445c2df2 2632
sqlite3_3.46.1-5.dsc
b634a90272eb00f174f015c2b1330adc0120de69bb0077849dee1440ee03c2cc 33908
sqlite3_3.46.1-5.debian.tar.xz
Files:
6a23bf073306120a22c408126e5500cf 2632 devel optional sqlite3_3.46.1-5.dsc
9f56d28b0fdc023e59790ed0dea913bf 33908 devel optional
sqlite3_3.46.1-5.debian.tar.xz
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCgAdFiEEfYh9yLp7u6e4NeO63OMQ54ZMyL8FAmg02vsACgkQ3OMQ54ZM
yL88aA//VBk6O6lt3XAYw3sTmSYFCn1rKqHMNktZ5cEepEh78Ftasv9pe6OwB9wj
0S4wxj15qiz5M2hLb28K/vYLxpwov4ePqduVJBaxCZ/k/up4Cw5puQP+6BN4b8G1
7chdopDClHVnK5fVYEIWtjyXxhbfQbc74GzF6GL9k1V+c/JP4vVPejTL340cwSP7
+RO5LfOcNdRJp4WN35eFyLLCrJR6BOh3bKMe+enUaeJ36sE06Wes760YSuSIwKi7
qRILGCh7nGsSc4RrtBewCa6AoUvuWljuZNzq+/wh6uI6jI4kuKLLx8FEZcLXQ4td
0o4b73YCa3bK2+o1vmbOpL950Ajox+w+tPtNJ/PAHoAKq6U2L9w7AUTIthy3qvjY
9F1DNNFCxi2jtM4vwLoZeyn+ext904CDyogYT94Gomb+4Ylbmq8zp9NCxur05kWP
1LSXRYrKUW50DvqAs9HTN/vYOR9lnR7giwttpN2vG1chVgArrst7EV35SzSWfmgy
1uPi1R9qi8SlAptBlD2XhZnSD8+YKc8kiTKHhPwyN3Bi+bUDikcJfAyYULVAAaqY
BzSlb2llOuOyCpiclW4ZmLbsk/xK2BMhauXBJ3QQhOGHFuEelWtJTMYwz7zJgkhz
yaxfOpGEuv8827KI1Jl9cDpdrQeYue/gXrFi6FLN1I+S0Yea1GE=
=fwCp
-----END PGP SIGNATURE-----
pgp2g3pYVbIpU.pgp
Description: PGP signature
--- End Message ---
