cheese8 commented on pull request #14239:
URL: https://github.com/apache/shardingsphere/pull/14239#issuecomment-999597203


   ShardingSphereException: The SQL clause '>' is unsupported in encrypt rule. 
should be thrown 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