db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Vandahl (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (TORQUE-353) DataTest.testLikeClauseEscaping fails on MySQL 5.7.16
Date Sun, 26 Aug 2018 10:53:00 GMT

     [ 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: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?

 

  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: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
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message