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