[TORQUE-353] DataTest.testLikeClauseEscaping fails on MySQL 5.7.16

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.0
• Fix Version/s: 5.0
• Component/s: Runtime, Test Project
• Assignee: Unassigned
• Reporter: Thomas Vandahl
• Created: 26/Aug/18 10:49
• Updated: 18/Dec/19 15:33
• Resolved: 18/Dec/19 15:33

Description

MySQL 5.7.16 on Mac OS X 10.11.6

DataTest.testLikeClauseEscaping tests if '%\\\\c' matches 'a\c' which fails.

This is actually a MySQL problem which can be reproduced on the command line:

mysql> select * from Author;
+-----------+------+
| author_id | name |
+-----------+------+
|      1728 | abc  |
|      1729 | bbc  |
|      1730 | a_c  |
|      1731 | a%c  |
|      1732 | a\c  |
|      1733 | a"c  |
|      1734 | a'c  |
|      1735 | a?c  |
|      1736 | a*c  |
+-----------+------+
9 rows in set (0,00 sec)

mysql> select * from Author where name like '%\\\\c';
Empty set (0,00 sec)

Strangely enough, the following succeeds:

mysql> select * from Author where name like '%\\\\\\c';
+-----------+------+
| author_id | name |
+-----------+------+
|      1732 | a\c  |
+-----------+------+
1 row in set (0,00 sec)

Any idea how to handle this?