You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "static0807 (via GitHub)" <gi...@apache.org> on 2023/06/27 08:54:53 UTC
[GitHub] [shardingsphere] static0807 opened a new issue, #26622: 【distSQL】CREATE ENCRYPT RULE，when i add LIKE_QUERY，it's always wrong
static0807 opened a new issue, #26622:
URL: https://github.com/apache/shardingsphere/issues/26622
## Question
my shardingsphere's version is 5.3.2
when i execute this SQL, it is OK
CREATE ENCRYPT RULE t_encrypt_2 (COLUMNS((NAME=user_id,PLAIN=user_plain,CIPHER=user_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc'))))), QUERY_WITH_CIPHER_COLUMN=FALSE);
but, i want use like query, so i added like query sql, it is :
CREATE ENCRYPT RULE t_encrypt_2 (COLUMNS((NAME=user_id,PLAIN=user_plain,CIPHER=user_cipher,LIKE_QUERY=user_like,ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc'))),LIKE_QUERY_ALGORITHM(TYPE(NAME='CRC16',PROPERTIES('cps-key-id'='123456abc'))))));
this one is always wrong
I have checked many times and I believe the grammar is correct，Please help me identify the problem，thanks
--
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] static0807 commented on issue #26622: 【distSQL】CREATE ENCRYPT RULE，when i add LIKE_QUERY，it's always wrong
Posted by "static0807 (via GitHub)" <gi...@apache.org>.
static0807 commented on issue #26622:
URL: https://github.com/apache/shardingsphere/issues/26622#issuecomment-1610561729
> @static0807 Is the execution result incorrect or an error is reported? please give specific error performance for troubleshooting.
I just resolved this issue because there is an error in the official PDF document
in the PDF doc, create encrypt rule use ' LIKE_QUERY = likeQueryColumnName'
this is wrong, but in online doc, it's 'LIKE_QUERY_COLUMN' , this is correct
in addition,the ASSISTED_QUERY_COLUMEN is also like this
please fix the pdf doc, thanks
--
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
[GitHub] [shardingsphere] Pace2Car commented on issue #26622: 【distSQL】CREATE ENCRYPT RULE，when i add LIKE_QUERY，it's always wrong
Posted by "Pace2Car (via GitHub)" <gi...@apache.org>.
Pace2Car commented on issue #26622:
URL: https://github.com/apache/shardingsphere/issues/26622#issuecomment-1610569654
It looks like your PDF download is the master version, this syntax has been refactored in an upcoming release.
--
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
[GitHub] [shardingsphere] Pace2Car commented on issue #26622: 【distSQL】CREATE ENCRYPT RULE，when i add LIKE_QUERY，it's always wrong
Posted by "Pace2Car (via GitHub)" <gi...@apache.org>.
Pace2Car commented on issue #26622:
URL: https://github.com/apache/shardingsphere/issues/26622#issuecomment-1609350564
@static0807 Please give specific error performance for troubleshooting.
--
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
[GitHub] [shardingsphere] github-actions[bot] commented on issue #26622: 【distSQL】CREATE ENCRYPT RULE，when i add LIKE_QUERY，it's always wrong
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #26622:
URL: https://github.com/apache/shardingsphere/issues/26622#issuecomment-1656865784
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
[GitHub] [shardingsphere] static0807 commented on issue #26622: 【distSQL】CREATE ENCRYPT RULE，when i add LIKE_QUERY，it's always wrong
Posted by "static0807 (via GitHub)" <gi...@apache.org>.
static0807 commented on issue #26622:
URL: https://github.com/apache/shardingsphere/issues/26622#issuecomment-1610442183
> @static0807 Is the execution result incorrect or an error is reported? please give specific error performance for troubleshooting.
sorry，i forgot it
this is the execution result :
thanks
--
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