Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.5, 10.0.6
-
None
-
None
-
Centos 6.4
Description
Since the switch to pcre, word boundary queries such as SELECT 'a word a' REGEXP '[[:<:]]word[[:>:]]'; no longer work because it tries to parse [[:<:]] as a character class name.
Hi James.
This is a non-standard extension in the old regex library.
We'll think what we can do to provide backward compatibility
for this syntax.
In the meanwhile please use this syntax with PCRE:
SELECT 'a word a' REGEXP '\\bword
b';