[GitHub] [shardingsphere] userkdg commented on issue #14506: on encrypt, subquery projections token error, cause sql executor throw sqlexception

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

userkdg commented on issue #14506:
URL: https://github.com/apache/shardingsphere/issues/14506#issuecomment-1004892130


   > Hi @userkdg What is your logicSQL? I checked this as below on master，not very good but 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`
   
   very thinks.
   yes. this is ok. it must to analyze out projections & (mutil ) subquery projections, and then
   i met two case
   - column projections
    like your example
   
   - shorthand projections case
   ``` 
   select b.* from (select a.address, a.address as addr2, … from ec_oms_order a) 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