[GitHub] [shardingsphere] cheese8 edited a comment on issue #14506: on encrypt, subquery projections token error, cause sql executor throw sqlexception

[GitBox <gi...@apache.org>]

cheese8 edited a comment on issue #14506:
URL: https://github.com/apache/shardingsphere/issues/14506#issuecomment-1004834507


   Hi @userkdg What is your logicSQL? I checked this as below on master，not very good but at it's ok:
   
   LogicSQL:
   
   `SELECT b.certificate_number, b.amount FROM (SELECT a.certificate_number as certificate_number, a.amount FROM t_account a WHERE a.amount = 1373) b`
   
   ActualSQL:
   
   `SELECT b.cipher_certificate_number AS certificate_number, b.cipher_amount AS amount FROM (SELECT a.cipher_certificate_number, a.assisted_query_certificate_number, a.cipher_amount FROM t_account a WHERE a.cipher_amount = 1373) b`


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