You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "chengxunhuang (via GitHub)" <gi...@apache.org> on 2023/09/26 07:46:48 UTC
[GitHub] [shardingsphere] chengxunhuang commented on issue #28590: Fuzzy Query SQL Rewriting Problem for Cryptographic Columns
chengxunhuang commented on issue #28590:
URL: https://github.com/apache/shardingsphere/issues/28590#issuecomment-1735007158
good,The configuration is as follows:

The query statement is as follows:
navicat Connect proxy Execute SQL SELECT * FROM test where col1 like '2%' ;
In proxy, the SQL is rewritten as : [INFO ] 2023-09-26 15:45:57.763 [ShardingSphere-Command-0] ShardingSphere-SQL - Actual SQL: 5e869ce2cf334acc8687bf21dfb51d34 ::: SELECT `test`.`id`, `test`.`col1` AS `col1`, `test`.`col2` FROM test where col1 like '1%'
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org