#1140285 sqlite3-pcre2: FTBFS: Parse error near line 105: no such column: "." - should this be a string literal in single-quotes? #1140285
- Package:
- src:sqlite3-pcre2
- Source:
- src:sqlite3-pcre2
- Submitter:
- Santiago Vila
- Date:
- 2026-06-18 16:37:03 UTC
- Severity:
- normal
- Tags:
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 --------------------------------------------------------------------------------
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-----