[
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)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
