Bug #106504 A regular expression is not supported in MySQL8, but is supported in MySQL5.7

• Submitted: 18 Feb 2022 8:57
• Modified: 18 Mar 2022 10:14
• Reporter: Brian Yue (OCA)
• Status: No Feedback
• Category: MySQL Server: DML
• Severity: S3 (Non-critical)
• Version: 8.0.27
• OS: Any (rhel-7.4)
• CPU Architecture: Any (x86-64)
• Tags: regression

[18 Feb 2022 8:57] Brian Yue

Description:
Hi,
  There is a regular expression, which is supported in MySQL5.7.22, but is not supported in MySQL8.0.27. The regular expression is like this:

  select 'a word a' REGEXP 'word[[:>:]]';

How to repeat:
Execute the SQL statement in MySQL5.7.22:

mysql> select 'a word a' REGEXP 'word[[:>:]]';
+---------------------------------+
| 'a word a' REGEXP 'word[[:>:]]' |
+---------------------------------+
|                               1 |
+---------------------------------+
1 row in set (0.00 sec)

Execute the SQL statement in MySQL8.0.27:

mysql> select 'a word a' REGEXP 'word[[:>:]]';
ERROR 3685 (HY000): Illegal argument to a regular expression.
mysql>

Suggested fix:
The SQL statement is expected to be executed successfully.

[18 Feb 2022 9:10] MySQL Verification Team

Hello Brian Yue,

Thank you for the report and feedback.

regards,
Umesh

[18 Feb 2022 10:07] Tor Didriksen

MySQL 8.0 uses ICU regexp, which is documented here:
https://unicode-org.github.io/icu/userguide/strings/regexp.html

[18 Feb 2022 10:13] Tor Didriksen

Posted by developer:
 
MySQL 8.0 uses ICU regexp, which is documented here:
https://unicode-org.github.io/icu/userguide/strings/regexp.html

[19 Mar 2022 1:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".