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:
   ![Snipaste_2023-09-26_14-44-07](https://github.com/apache/shardingsphere/assets/56817751/8231ccde-ed67-4a11-a4b0-4601404beb66)
   
   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