Bug #89461 RLIKE and REGEXP are not a synonym of REGEXP_LIKE in 5.7 and ealier
Submitted: 30 Jan 2018 4:29 Modified: 31 Jan 2018 14:37
Reporter: Tsubasa Tanaka (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.7, 5.6, 5.5 OS:Any
Assigned to: CPU Architecture:Any

[30 Jan 2018 4:29] Tsubasa Tanaka 
Description:
MySQL 5.7, 5.6 and 5.5 docs describe "RLIKE Synonym for REGEXP_LIKE()" but REGEXP_LIKE introduces from MySQL 8.0.

How to repeat:
See, 

https://dev.mysql.com/doc/refman/5.7/en/regexp.html
https://dev.mysql.com/doc/refman/5.6/en/regexp.html
https://dev.mysql.com/doc/refman/5.5/en/regexp.html

```
mysql57 3> SELECT @@version;
+------------+
| @@version  |
+------------+
| 5.7.21-log |
+------------+
1 row in set (0.00 sec)

mysql57 3> SELECT REGEXP_LIKE('MySQL', 'MySQL');
ERROR 1046 (3D000): No database selected

mysql57 3> use d1
Database changed

mysql57 3> SELECT REGEXP_LIKE('MySQL', 'MySQL');
ERROR 1305 (42000): FUNCTION d1.REGEXP_LIKE does not exist
```

Suggested fix:
Fix the docs
[30 Jan 2018 4:32] Tsubasa Tanaka 
Old docs describes them as "REGEXP Pattern matching using regular expressions", "RLIKE Synonym for REGEXP"in revision: 49610 (5.7)
[30 Jan 2018 4:33] MySQL Verification Team 
Hello Tanaka-San,

Thank you for the report and feedback!

Thanks,
Umesh
[31 Jan 2018 14:37] Paul DuBois 
Posted by developer:
 
Fixed, thanks for spotting this.