Your message dated Wed, 19 Feb 2025 21:57:46 +0000
with message-id <e1tks4g-00brpu...@fasolo.debian.org>
and subject line Bug#1095286: fixed in mariadb 1:11.4.5-1
has caused the Debian Bug report #1095286,
regarding mariadb: FTBFS with pcre2 10.45 due to incorrect case-insensitive
regex test
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.)
--
1095286: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1095286
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Source: mariadb
Version: 1:11.4.4-3
Severity: serious
Justification: FTBFS, blocks pcre2 migration
Hi,
The mariadb REGEXP function (which RLIKE is an alias of) uses
case-insensitive matching (except for binary strings)[0]
In perl, the Unicode character properties Uppercase_Letter,
Lowercase_Letter, and Titlecase_Letter all match Cased_Letter under /i
(case-insensitive matching)[1]
PCRE2 version 10.45 fixes its behaviour in this area to match Perl[2]
The Mariadb func_regexp_pcre.test tests currently check for the old,
incorrect behaviour in the Unicode character class tests, meaning the CI
tests fail[3]
For example, you can see that the test is expecting (line 3294 in CI
output):
-\p{Ll} A 0
i.e. that \p{Ll} will not match on 'A'. But you can see that perl does
match that:
matthew@aragorn:~$ perl -E "say 'matches' if 'A' =~ /\p{Ll}/i;"
matches
Likewise, you can see that the test is expecting (line 3321 in CI output):
-\p{Lu} я 0
i.e. that \p{Lu} will not match on 'я'. Again, perl does:
matthew@aragorn:~$ perl -E "say 'matches' if 'я' =~ /\p{Lu}/i;"
matches
The correct answer is to either drop the case-sensitive tests here
entirely (i.e. replace line 44 of func_regexp_pcre.tests with just
INSERT INTO t2 VALUES ('\\p{L}'),('\\p{L&}');) or to force the test data
to be treated as binary (which I think is less useful), and then adjust
the expected results to match.
Thanks,
Matthew
[0] https://mariadb.com/kb/en/regexp/
[1] https://perldoc.perl.org/perlunicode#Unicode-Character-Properties
[2] https://github.com/PCRE2Project/pcre2/blob/master/ChangeLog#L34C1-L37C30
[3] https://ci.debian.net/packages/m/mariadb/testing/amd64/57496769/#L3287
--- End Message ---
--- Begin Message ---
Source: mariadb
Source-Version: 1:11.4.5-1
Done: Otto Kekäläinen <o...@debian.org>
We believe that the bug you reported is fixed in the latest version of
mariadb, 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 1095...@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Otto Kekäläinen <o...@debian.org> (supplier of updated mariadb 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: Wed, 19 Feb 2025 08:57:57 -0800
Source: mariadb
Architecture: source
Version: 1:11.4.5-1
Distribution: unstable
Urgency: medium
Maintainer: Debian MySQL Maintainers <pkg-mysql-ma...@lists.alioth.debian.org>
Changed-By: Otto Kekäläinen <o...@debian.org>
Closes: 1095286
Changes:
mariadb (1:11.4.5-1) unstable; urgency=medium
.
[ Otto Kekäläinen ]
* New upstream version 11.4.5. Includes fixes for several defects
as noted at https://mariadb.com/kb/en/mariadb-11-4-5-release-notes/ as well
the following security issues:
- CVE-2025-21490
* Include new packaging changes done upstream:
- MDEV-35907: debian-start script fails when using non-standard socket path
- MCOL-5819: Disable LTO for ColumnStore, otherwise enabled by default
- MDEV-32686: Include ELF package notes
* Update configuration traces to match changes done in MDEV-35785
* Update configuration traces with new query allocator values from MDEV-35750
* Build MariaDB RocksDB on loong64 now too
* Fix minor typos in Debian packaging files
* Fix broken links in d/copyright
* Unify spelling fix patches into one, and fix spelling of Enrypt->Encrypt
.
[ Matthew Vernon ]
* Add patch to fix `main.func_regexp_pcre` failing with latest PCRE2 10.45
due to backwards-incompatible case-sensitivity change in behavior in latest
PCRE2 version (Closes: #1095286)
.
[ Joe Bliss ]
* Revert backticks change in commit 0300a915 to be compatible with databases
containing hyphenated table names (LP: #2085554)
Checksums-Sha1:
1b5f359799f98323800a778b89058ab22dd3c464 5621 mariadb_11.4.5-1.dsc
dc69248eacefe9d9d34511c3251959bb7a4524a9 112382453 mariadb_11.4.5.orig.tar.gz
423a5f9c7119a43708e8a79d72dab03dd28dbdb0 833 mariadb_11.4.5.orig.tar.gz.asc
46c73cc2267839d61c41b447cf3752d4168c5e1b 285176 mariadb_11.4.5-1.debian.tar.xz
5ce0b2c02f08a5d270620c3dde8157673df4f2e2 13665
mariadb_11.4.5-1_source.buildinfo
Checksums-Sha256:
593aef04fdd8296035a13c5c2f3638a9e82b482741b825e984f0c02a95803315 5621
mariadb_11.4.5-1.dsc
ff6595f8c482f9921e39b97fa1122377a69f0dcbd92553c6b9032cbf0e9b5354 112382453
mariadb_11.4.5.orig.tar.gz
9a5a34d0e7e8e8c7271aab3eba17ba0a5ed957e7db233e4c5961f1d1d7525847 833
mariadb_11.4.5.orig.tar.gz.asc
72833248825b73a586f94dd44701dba19fe585e9e2cd901ed9233bfb4be3764a 285176
mariadb_11.4.5-1.debian.tar.xz
39f0e6fc3ce03c8ed845231918b807238ab75222a372d7a1489b9ebdf31db0d5 13665
mariadb_11.4.5-1_source.buildinfo
Files:
e9af6488f6f844e2c7d4f2c0ded8da0c 5621 database optional mariadb_11.4.5-1.dsc
49a28cc68710e0e3b030e90579eec7db 112382453 database optional
mariadb_11.4.5.orig.tar.gz
9d420c7b569a03dac53ae87ba006e4d6 833 database optional
mariadb_11.4.5.orig.tar.gz.asc
a832c75bdf72ac6f76793440a4f971bb 285176 database optional
mariadb_11.4.5-1.debian.tar.xz
7e5d907d95e68eb5eab0b32594d83fde 13665 database optional
mariadb_11.4.5-1_source.buildinfo
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCgAdFiEEmbRSsR88dMO0U+RvvthEn87o2ogFAme2TnsACgkQvthEn87o
2ogKCg/+POwJwz807nxkUWcgQ4SQ5h9lKX0GDPD2sqeoqFa8jiswReyFVfb5HJY3
41xyxkpOblBIjd/t2mPFcXdtgDUjHTiUWHLM8R5FUCa6VIx96mqefe784F3fKEN1
t1ZsfuTmyP/LO1RJchWzNnCj9ul1p+UKLqzCfF0jsbZo4O+2sQigs9iJ3alfOxhI
rydng+itRkKFmH+Ellq1n0/qx8cj+pgNeEVuUEFMczrB0NzTyfJlJKanPLKElS3U
34YyJMowZBCEEqTnqBbNBt7gnOI0ry/kcDjUq29iylsiC8WIY74PgakLrMY7YtN6
j06mkb1EPKJpfS6yycH+C/MQpcwXDEKyNN3aB1FmHJkzTIRNYIBkyRVUZltDhLbq
QfBAGZJQyJsQkiRsKsNXFjO7tkv5VoGD2/sy8csabCKUa4Zi+gcdBbKtn0baVWOh
EvnC4T5KFR9q7tGjYvAvpSBvZRGJ0Ef90K7fn/wyKQomHa8SmWYhlKppLYe/+krH
lV7g6B3XvZUHSDh1i4JzxzdskznCmMSRLpqa6GAk7OUnlH+W/zf1gFX9/C7XMQwt
5I6pEDhrQFnuE7EWv3uxi1yVg/JnuWRVawBVNnOT+Q2LLfzgD7olS0ZCUYPdG6Ew
DcUN6zj0tasN31KySWOfVj4a4jnB5Bll0Rio5uwloFY+vTKhCNc=
=dFf9
-----END PGP SIGNATURE-----
pgphOPgPWtz4N.pgp
Description: PGP signature
--- End Message ---
