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:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
