[GitHub] [shardingsphere] chinaxlt opened a new issue, #24618: sql rewrite issue

["chinaxlt (via GitHub)" <gi...@apache.org>]

chinaxlt opened a new issue, #24618:
URL: https://github.com/apache/shardingsphere/issues/24618

   origin sql ->
   select distinct id from (select distinct id from table_a where id = 1 union all select distinct id from table_b where id = 1) as tem
   
   rewrite sql ->
   select distinct id from (select distinct id from table_a_01 where id = 1 union all select distinct id from table_b_01 ORDER BY id ASC  where id = 1) as tem
    
   ORDER BY id ASC cause an error in the rewrite SQL
   


-- 
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] strongduanmu commented on issue #24618: sql rewrite issue

["strongduanmu (via GitHub)" <gi...@apache.org>]

strongduanmu commented on issue #24618:
URL: https://github.com/apache/shardingsphere/issues/24618#issuecomment-1469526404

   Hi @chinaxlt, thank you for your feedback. Currently, the ShardingSphere does not support subqueries, so you need to make some changes to the logical SQL.


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