Thomas Vandahl created TORQUE-353:
-------------------------------------
Summary: DataTest.testLikeClauseEscaping fails on MySQL 5.7.16
Key: TORQUE-353
URL: https://issues.apache.org/jira/browse/TORQUE-353
Project: Torque
Issue Type: Bug
Components: Runtime, Test Project
Affects Versions: 4.1
Reporter: Thomas Vandahl
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:
{code:java}
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)
{code}
Strangely enough, the following succeeds:
{code:java}
mysql> select * from Author where name like '%\\\\\\c';
+-----------+------+
| author_id | name |
+-----------+------+
| 1732 | a\c |
+-----------+------+
1 row in set (0,00 sec)
{code}
Any idea how to handle this?
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscr...@db.apache.org
For additional commands, e-mail: torque-dev-h...@db.apache.org
