Your message dated Mon, 26 Oct 2026 18:35:11 +0000
with message-id <[email protected]>
and subject line Bug#1150893: fixed in sqlite3-pcre2
0.1.1~git20220105-e3e02a4a-4
has caused the Debian Bug report #1150893,
regarding sqlite3-pcre2: Please mark REGEXP as SQLITE_DETERMINISTIC and
SQLITE_INNOCUOUS
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 [email protected]
immediately.)
--
1150893: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1150893
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: sqlite3-pcre2
Version: 0.1.1~git20220105-e3e02a4a-3
Severity: minor
Tags: upstream patch
X-Debbugs-Cc: [email protected]
SQLITE_DETERMINISTIC lets sqlite better optimize queries that use REGEXP and is
required to use it in partial indexes.
SQLITE_INNOCUOUS would be nice to have but only matters when TRUSTED_SCHEMA is
turned off.
https://sqlite.org/c3ref/c_deterministic.html#sqlitedeterministic
SQLITE_DETERMINISTIC
The SQLITE_DETERMINISTIC flag means that the new function always gives the
same output when the input parameters are the same. The abs() function is
deterministic, for example, but randomblob() is not. Functions must be
deterministic in order to be used in certain contexts such as with the WHERE
clause of partial indexes or in generated columns. SQLite might also optimize
deterministic functions by factoring them out of inner loops.
https://sqlite.org/c3ref/c_deterministic.html#sqliteinnocuous
SQLITE_INNOCUOUS
The SQLITE_INNOCUOUS flag means that the function is unlikely to cause
problems even if misused. An innocuous function should have no side effects and
should not depend on any values other than its input parameters. The abs()
function is an example of an innocuous function. The load_extension() SQL
function is not innocuous because of its side effects.
SQLITE_INNOCUOUS is similar to SQLITE_DETERMINISTIC, but is not exactly the
same. The random() function is an example of a function that is innocuous but
not deterministic.
Some heightened security settings (SQLITE_DBCONFIG_TRUSTED_SCHEMA and
PRAGMA trusted_schema=OFF) disable the use of SQL functions inside views and
triggers and in schema structures such as CHECK constraints, DEFAULT clauses,
expression indexes, partial indexes, and generated columns unless the function
is tagged with SQLITE_INNOCUOUS. Most built-in functions are innocuous.
Developers are advised to avoid using the SQLITE_INNOCUOUS flag for
application-defined functions unless the function has been carefully audited
and found to be free of potentially security-adverse side-effects and
information-leaks.
change pcre2.c line 157 from
```sqlite3_create_function(db, "REGEXP", 2, SQLITE_UTF8, cache, regexp, NULL,
NULL);```
to
```sqlite3_create_function(db, "REGEXP", 2,
SQLITE_UTF8|SQLITE_DETERMINISTIC|SQLITE_INNOCUOUS, cache, regexp, NULL,
NULL);```
-- System Information:
Debian Release: forky/sid
APT prefers testing
APT policy: (990, 'testing'), (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 7.2.9+deb14-amd64 (SMP w/16 CPU threads; PREEMPT)
Locale: LANG=en_CA.UTF-8, LC_CTYPE=en_CA.UTF-8 (charmap=UTF-8),
LANGUAGE=en_CA:en
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages sqlite3-pcre2 depends on:
ii libc6 2.43-7
ii libpcre2-8-0 10.48-3.1
sqlite3-pcre2 recommends no packages.
sqlite3-pcre2 suggests no packages.
-- no debconf information
--- End Message ---
--- Begin Message ---
Source: sqlite3-pcre2
Source-Version: 0.1.1~git20220105-e3e02a4a-4
Done: Dominique Dumont <[email protected]>
We believe that the bug you reported is fixed in the latest version of
sqlite3-pcre2, 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 [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Dominique Dumont <[email protected]> (supplier of updated sqlite3-pcre2 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 [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Format: 1.8
Date: Mon, 26 Oct 2026 19:02:46 +0100
Source: sqlite3-pcre2
Architecture: source
Version: 0.1.1~git20220105-e3e02a4a-4
Distribution: unstable
Urgency: medium
Maintainer: Dominique Dumont <[email protected]>
Changed-By: Dominique Dumont <[email protected]>
Closes: 1150893
Changes:
sqlite3-pcre2 (0.1.1~git20220105-e3e02a4a-4) unstable; urgency=medium
.
* add patch to set SQLITE_DETERMINISTIC | SQLITE_INNOCUOUS flags
(Closes: 1150893)
Checksums-Sha1:
fee7f231dfded8c44dec12631b37eb2f2a11fa28 2168
sqlite3-pcre2_0.1.1~git20220105-e3e02a4a-4.dsc
0ca3e2bb564c4d9f2902f52252ca8d94bbb474c4 5188
sqlite3-pcre2_0.1.1~git20220105-e3e02a4a-4.debian.tar.xz
78cd75a76dc68f553a67986ad88747c95260affe 7137
sqlite3-pcre2_0.1.1~git20220105-e3e02a4a-4_source.buildinfo
Checksums-Sha256:
66b932528a2ac530abe61efe4ffcdba71c440f4a2aed122d776fc573af4d3536 2168
sqlite3-pcre2_0.1.1~git20220105-e3e02a4a-4.dsc
1e3732c00d897b180dea42abd3055bf576788c94d8afbe62c4edeb75c7c37b4d 5188
sqlite3-pcre2_0.1.1~git20220105-e3e02a4a-4.debian.tar.xz
6af623cc90b3d2d658f283b61fe1f4e93dd74efeab2efb0bc4891dfda34ab829 7137
sqlite3-pcre2_0.1.1~git20220105-e3e02a4a-4_source.buildinfo
Files:
6f994d1e5ff1f1ec5daf2d3279c2ee78 2168 libs optional
sqlite3-pcre2_0.1.1~git20220105-e3e02a4a-4.dsc
d12bbbd1a3ccfc40b6d6802d4e6b2118 5188 libs optional
sqlite3-pcre2_0.1.1~git20220105-e3e02a4a-4.debian.tar.xz
ee44c909a019df5e486cb4107d8f6271 7137 libs optional
sqlite3-pcre2_0.1.1~git20220105-e3e02a4a-4_source.buildinfo
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCgAdFiEEn3I5/LZk8Qsz6dwDwx9P2UmrK2wFAmrfmbcACgkQwx9P2Umr
K2zqOxAAnKriNi/i7siZNp2aKb/17xMOsOWAiAG1V2jzUbxbsHtfWM8CPDaXaTaF
t9DA7MIyfSul+HtNFpe5IyJY+4BWN+KQmOuRjMxK90+qyrL428gnUYFpQD6iTRKh
Wsj4l2hwK0xEJY4rYGk8aiHWDs5CnjWHVeNDtozL6GzsRHGD5Q7tkA3Tqb2AkW6+
NLVN7KUXR4flKpu0HuYIt8oTakFoFhxi86U8PGRPbJl5VJ1DQy8aT27/JhwLXvNh
GBPv9Y/qIkf5IaPGHwqE54MZze8TQ+nR86gNd8LduaKJZUMRjvq2XuhWto7Jcq1L
/Uv9EcCdSPrzKi7dmumWBmHZAfFl41BLj2oZ//bq15uK5j4AhJiBRBrKNFiYbSjH
0084ZLtXUnTMHg8hPoJscHdMLEYyiez7rBlHiB2TNbCVutVB90VBApW3wWIF9I9q
zGehiCeB7sCVWh1GUi5xqy2bdctmRyT2HHIslvdFmc1i9ugdL0tgAdWuLO7CpUC+
k0FZjOAqUgg1YZlmC+XGtCiN0uWCIkYktHvVXAkp51WV0N/Qbj3HeBlFKw8AEaQD
A7KEBJJ157aDbZeB49Lz2ip72m8Y2jFtIc2hHSOLYm0IQsPGDMSCHLXhfJ+8vnEO
q+NZ6zFJ1/rP4Lklvy7CjEledSNfv0sGIKmiow1ze6kNDkW2q/w=
=f1pT
-----END PGP SIGNATURE-----
pgpJG8D71ZZYQ.pgp
Description: PGP signature
--- End Message ---