Bug #92619 Regexp binary
Submitted: 1 Oct 2018 12:41 Modified: 1 Nov 2018 14:43
Reporter: ali koyuncu Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:8.0.12 OS:Mac OS X ( osx10.13)
Assigned to: CPU Architecture:Any (x86_64)
Tags: rexep

[1 Oct 2018 12:41] ali koyuncu
Description:
regexp binary doesn't work

SELECT 'a' REGEXP 'A', 'A' REGEXP BINARY 'A';
+----------------+-----------------------+
| 'a' REGEXP 'A' | 'A' REGEXP BINARY 'A' |
+----------------+-----------------------+
|              1 |                     0 |
+----------------+-----------------------+

I opened a question on stackoverflow, you can find more information there:

https://stackoverflow.com/questions/52590741/mysql-8-regular-expression-binary-problem

How to repeat:
Always
[1 Oct 2018 14:43] Miguel Solorzano
Thank you for the bug report. Please provide your my.cnf (use Files tab, private).

miguel:~ miguel$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 8.0.12 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SHOW VARIABLES LIKE "%VERSION%";
+-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 8.0.12                       |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| tls_version             | TLSv1,TLSv1.1,TLSv1.2        |
| version                 | 8.0.12                       |
| version_comment         | MySQL Community Server - GPL |
| version_compile_machine | x86_64                       |
| version_compile_os      | macos10.13                   |
| version_compile_zlib    | 1.2.11                       |
+-------------------------+------------------------------+
9 rows in set (0.00 sec)

mysql> SELECT 'a' REGEXP 'A', 'A' REGEXP BINARY 'A';
+----------------+-----------------------+
| 'a' REGEXP 'A' | 'A' REGEXP BINARY 'A' |
+----------------+-----------------------+
|              1 |                     1 |
+----------------+-----------------------+
1 row in set (0.00 sec)
[2 Nov 2018 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".