You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "yuyinw (via GitHub)" <gi...@apache.org> on 2023/07/13 02:20:33 UTC

[GitHub] [shardingsphere] yuyinw opened a new issue, #26932: CHAR_DIGEST_LIKE issue

yuyinw opened a new issue, #26932:
URL: https://github.com/apache/shardingsphere/issues/26932

   ### Which version of ShardingSphere did you use?
   5.3.2
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   ### Expected behavior
   CHAR_DIGEST_LIKE,  search result  is right
   ### Actual behavior
   1. my test table has two record:
   
      id       name     phone                 email                         salary
      1        lihu       13877777777       243433@qq.com       15000
      2        liming    13888888888      243232@qq.com       15002
   
   2.  my config:
   like encryptor:
        type: CHAR DIGEST LIKE
   md5 encryptor:
         type:MD5
   tables:
          tbl_info:
          columns:
              salary:
                     cipherColumn: salary
                      encryptorName: aes encryptor
                      assistedQueryColumn:  salary 
                       assistassistedQueryEncryptorName: md5_encryptor
                      likeQueryColumn: salary_like
                       likeQueryEncryptorName: like_encryptor
   
   4. when i search salary like %2, the result is wrong
   
   SELECT *FROM "tbl_info" WHERE (salary like '%2')
   [2 rows affected or returned ]
   success5
   [{1 lihu 138****7777 ******@qq.com 15000} {2 liming 138****8888 ******@qq.com 15002}]
       
   ### Reason analyze (If you can)
   15000 and 15002 using CHAR_ DIGEST_ LIKE fuzzy query algorithm, all results are 04111
   so it can not search right result
   


-- 
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.apache.org

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


[GitHub] [shardingsphere] github-actions[bot] commented on issue #26932: CHAR_DIGEST_LIKE issue

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #26932:
URL: https://github.com/apache/shardingsphere/issues/26932#issuecomment-1682904170

   There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.


-- 
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


Re: [I] CHAR_DIGEST_LIKE issue [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #26932:
URL: https://github.com/apache/shardingsphere/issues/26932#issuecomment-2230751148

   The markdown format in your issue is incorrect. To facilitate reading, could you please revise it?


-- 
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


Re: [I] CHAR_DIGEST_LIKE issue [shardingsphere]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #26932:
URL: https://github.com/apache/shardingsphere/issues/26932#issuecomment-2259120313

   There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.


-- 
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


Re: [I] CHAR_DIGEST_LIKE issue [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #26932: CHAR_DIGEST_LIKE  issue
URL: https://github.com/apache/shardingsphere/issues/26932


-- 
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