cheese8 opened a new issue #14248:
URL: https://github.com/apache/shardingsphere/issues/14248


   should throw ShardingSphereException while the SQL clause was not support in 
encrypt rule.
   
   The SQL clause '%operator%' is unsupported in encrypt rule. 
   
   For example, the operator ">" as below sql:
   
   LogicSQL:
   select t_account.certificate_number, t_account.amount, 
t_account_bak.certificate_number from t_account, t_account_bak where 
t_account.certificate_number = t_account_bak.certificate_number and 
t_account.amount > ?
   
   ActualSQL:
   select t_account.cipher_certificate_number AS certificate_number, 
t_account.cipher_amount AS amount, t_account_bak.cipher_certificate_number AS 
certificate_number from t_account, t_account_bak where 
t_account.assisted_query_certificate_number = 
t_account_bak.assisted_query_certificate_number and t_account.cipher_amount > ?
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to