[ https://issues.apache.org/jira/browse/TORQUE-353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Vandahl updated TORQUE-353: ---------------------------------- 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: {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? was: 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? > 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: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