Today we upgraded the PCRE library bundled with MariaDB-10.0 to PCRE-8.34. This PCRE release includes some improvements, fixes for better stability and performance, and gives more compatibility with the Perl regular expressions.
I’d like to give details on the PCRE changes that especially affected MariaDB.
PCRE now includes support
for [[:<:]] and [[:>:]]
as used in the BSD POSIX library (written by Henry Spencer) to
mean “start of word” and “end of word“,
respectively. This is a good news for those project (like
MariaDB) migrating from the Henry Spencer’s library to PCRE, as
this non-standard syntax seemed to be used quite widely. Many
thanks to Philip Hazel and the PCRE team who kindly added this
extension into …