yangzhg opened a new issue #3803: URL: https://github.com/apache/incubator-doris/issues/3803
In clause like ``` select a from t order by a union all select b from t ``` The ORDER BY clause in subquery `select a from t order by a` is unmeaningful , so a query expression that precedes a set operator should not contain an ORDER BY clause. We can remove the order by clause to impove the preformance. This also applies to subquery in from clause， the ORDER BY also need to remove. ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
