#1140285 sqlite3-pcre2: FTBFS: Parse error near line 105: no such column: "." - should this be a string literal in single-quotes?

#1140285#5
Date:
2026-06-17 16:16:06 UTC
From:
To:
Dear maintainer:

During a rebuild of all packages in unstable, this package failed to build.

Below you will find the last part of the build log (probably the most
relevant part, but not necessarily). If required, the full build log
is available here:

https://people.debian.org/~sanvila/build-logs/202606/

About the archive rebuild: The build was made on virtual machines from AWS,
using sbuild and a reduced chroot with only build-essential packages.

If you cannot reproduce the bug please contact me privately, as I
am willing to provide ssh access to a virtual machine where the bug is
fully reproducible.

If this is really a bug in one of the build-depends, please use
reassign and add an affects on src:sqlite3-pcre2, so that this is still
visible in the BTS web page for this package.

Thanks.
--------------------------------------------------------------------------------
[...]
 debian/rules clean
dh clean
   dh_auto_clean
	make -j2 clean
make[1]: Entering directory '/<<PKGBUILDDIR>>'
rm -f pcre2.so test/db.sqlite3 test/*.phony
make[1]: Leaving directory '/<<PKGBUILDDIR>>'
   dh_clean
 debian/rules binary
dh binary
   dh_update_autotools_config
   dh_autoreconf
   dh_auto_configure
   dh_auto_build
	make -j2 INSTALL="install --strip-program=true"
make[1]: Entering directory '/<<PKGBUILDDIR>>'
cc -shared -o pcre2.so -g -O2 -Werror=implicit-function-declaration -ffile-prefix-map=/<<PKGBUILDDIR>>=. -fstack-protector-strong -fstack-clash-protection -Wformat -Werror=format-security -fcf-protection   -fPIC -W -Werror pcre2.c -lpcre2-8 -Wl,-z,relro -Wl,-z,now
make[1]: Leaving directory '/<<PKGBUILDDIR>>'
   dh_auto_test
	make -j2 check
make[1]: Entering directory '/<<PKGBUILDDIR>>'
cat test/10-init/10-create-schema.sql test/10-init/20-testregexp.sql | sqlite3 test/db.sqlite3
Parse error near line 105: no such column: "." - should this be a string literal in single-quotes?
       || ' '             || `match`             || "."         ELSE
                                      error here ---^
make[1]: *** [Makefile:23: test/db.sqlite3] Error 1
make[1]: Leaving directory '/<<PKGBUILDDIR>>'
dh_auto_test: error: make -j2 check returned exit code 2
make: *** [debian/rules:23: binary] Error 25
dpkg-buildpackage: error: debian/rules binary subprocess failed with exit status 2
--------------------------------------------------------------------------------

#1140285#10
Date:
2026-06-18 16:36:19 UTC
From:
To:
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 1140285@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Dominique Dumont <dod@debian.org> (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 ftpmaster@ftp-master.debian.org)
Format: 1.8
Date: Thu, 18 Jun 2026 18:17:40 +0200
Source: sqlite3-pcre2
Architecture: source
Version: 0.1.1~git20220105-e3e02a4a-3
Distribution: unstable
Urgency: medium
Maintainer: Dominique Dumont <dod@debian.org>
Changed-By: Dominique Dumont <dod@debian.org>
Closes: 1140285
Changes:
 sqlite3-pcre2 (0.1.1~git20220105-e3e02a4a-3) unstable; urgency=medium
 .
   * add patch to fix test (Closes: #1140285)
   * control: declare compliance with Debian policy 4.7.4
   * control: update debhelper-compat to 14
   * control: set dh-sequence-single-binary in Build-Depends
Checksums-Sha1:
 529a471538b8c42ae2a8d8a80f1232e3c307074a 2168 sqlite3-pcre2_0.1.1~git20220105-e3e02a4a-3.dsc
 24be7ba4b356db50a80a490690bb5e8a309c3d10 3720 sqlite3-pcre2_0.1.1~git20220105-e3e02a4a-3.debian.tar.xz
 4ea2c1d0bda45f4f00b9af310eae15b1f0f150f8 6802 sqlite3-pcre2_0.1.1~git20220105-e3e02a4a-3_source.buildinfo
Checksums-Sha256:
 3ab315c7399bab4022affd31525c5f7797e875349632c3a60ee369d4c3ea02be 2168 sqlite3-pcre2_0.1.1~git20220105-e3e02a4a-3.dsc
 d66d13b52e04dcdd57b7dd828821bb17a642370470be063e948dabf11006d575 3720 sqlite3-pcre2_0.1.1~git20220105-e3e02a4a-3.debian.tar.xz
 7bf39076729bb1cc4b174d294eda9f92ae60689b54f0fadd972e8fa8076dd4c3 6802 sqlite3-pcre2_0.1.1~git20220105-e3e02a4a-3_source.buildinfo
Files:
 c8b6a2b409f375950cd3862cb0c40aec 2168 libs optional sqlite3-pcre2_0.1.1~git20220105-e3e02a4a-3.dsc
 86aee9189b9701a036a3019015c6c853 3720 libs optional sqlite3-pcre2_0.1.1~git20220105-e3e02a4a-3.debian.tar.xz
 bd3b189a50a65bfcf566a873a5792fb2 6802 libs optional sqlite3-pcre2_0.1.1~git20220105-e3e02a4a-3_source.buildinfo
-----BEGIN PGP SIGNATURE-----

iQIzBAEBCgAdFiEEn3I5/LZk8Qsz6dwDwx9P2UmrK2wFAmo0GnUACgkQwx9P2Umr
K2wN1w//e35ie39uZ90tV8fVJrrtbS6c0daOeq7nR1Qs2jADNlSFlFFGwjasTnj3
rxmAi97bO0W8pEOT1b1xn3YtEFuwuMk/5iBbENgX0Pr1ea0gYlpRQk4Mb2ElIn24
S05/0QTi3haHY+vaWcMLknoKrh6O/eNqmXrh9ujAG1xVsL0sqd1eOSkPGcdDpbqR
jc/Y4q3WFiljiYI2yjCJn97GcQ+dvtRXbAE/Etf1MOp+8HoSglZedL3c+qokDfxN
yz7F6yK9wldDHOoeCLu9vuhYS6OtUMnO2W/i0ddYETWwKkSM4O0ZuX4jm/cghyNU
99NGdbs3nwJk4f1+hELI/1/CDH+Ngkm2p6ukrB86NAs7ha6/nm1dnQti2wCjflVx
y0V3B9F+Dblk8BEmyZb9H3TsMz18nT3Y59+ojaXyt9TACUUVLpvy09kibkvrtPnY
ekdt95hD9AFNQXzWAOmL7URHp9wpWncHe7mwT7+pHFMUlwiQ9fT+hzGJ2UmpnxP1
TrnBgEKPj3s5dcZqKbFMiSwkhFIywQV6vRKDzsyCMB5lCLE97rKG7NCZbGbade33
TP+bkJbP0n86W7WN4SBNoUO+84vGMHS/yrwIDCOv6CuJCD6x1MW08d7XPMNzKPpf
rkJhAG+pQKBAtb/48iOk+5c8Xb0ffHSI7w/RluCCFxIB0Gv6Gdc=
=XQuE
-----END PGP SIGNATURE-----