[GitHub] [shardingsphere] goool opened a new issue #7561: Single quote mark) is not supported in LIKE clause

[GitBox <gi...@apache.org>]

goool opened a new issue #7561:
URL: https://github.com/apache/shardingsphere/issues/7561


   ### Which version of ShardingSphere did you use?
   5.0.0-RC1-SNAPSHOT, git commit hash: f601d558de
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   ### Expected behavior
   mysql> select id from admin where fullname like "%a";
   Empty set (0.00 sec)
   mysql> select id from admin where fullname like "%a";
   Empty set (0.00 sec)
   mysql> select id from admin where fullname like '%a';
   Empty set (0.00 sec)
   mysql> select id from admin where fullname like 'a%';
   Empty set (0.00 sec)
   
   ### Actual behavior
   mysql> select id from admin where fullname like "%a";
   Empty set (0.00 sec)
   mysql> select id from admin where fullname like "%a";
   Empty set (0.00 sec)
   mysql> select id from admin where fullname like '%a';
   ERROR 10002 (C1000): 2Unknown exception: [Format specifier '%a']
   mysql> select id from admin where fullname like 'a%';
   ERROR 10002 (C1000): 2Unknown exception: [Conversion = ''']
   
   ### Reason analyze (If you can)
   It seems like " (double quote mark) is supported in LIKE clause, but ' (single quote mark) is not supported. 


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] goool closed issue #7561: Single quote mark) is not supported in LIKE clause

[GitBox <gi...@apache.org>]

goool closed issue #7561:
URL: https://github.com/apache/shardingsphere/issues/7561


   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] goool closed issue #7561: Single quote mark) is not supported in LIKE clause

[GitBox <gi...@apache.org>]

goool closed issue #7561:
URL: https://github.com/apache/shardingsphere/issues/7561


   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org