[jira] [Commented] (TORQUE-353) DataTest.testLikeClauseEscaping fails on MySQL 5.7.16

    [ https://issues.apache.org/jira/browse/TORQUE-353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16999251#comment-16999251 ] 

Georg Kallidis commented on TORQUE-353:
---------------------------------------

Mysql 8.0.18, linux:
{code:sql}
mysql> SELECT author.author_id, author.name, author.name LIKE '%\\\\c' FROM author;
+-----------+------+---------------------------+
| author_id | name | author.name LIKE '%\\\\c' |
+-----------+------+---------------------------+
|         1 | abc  |                         0 |
|         2 | bbc  |                         0 |
|         3 | a_c  |                         0 |
|         4 | a%c  |                         0 |
|         5 | a\c  |                         1 |
|         6 | a"c  |                         0 |
|         7 | a'c  |                         0 |
|         8 | a?c  |                         0 |
|         9 | a*c  |                         0 |
+-----------+------+---------------------------+
9 rows in set (0.00 sec)
{code}
This seems now again as expected + Torque 4.1 targets MySQL 8.

> 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
>            Priority: Major
>
> 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:sql}
> 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:sql}
> 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
(v8.3.4#803005)