-
Notifications
You must be signed in to change notification settings - Fork 3k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Ignore order by in a from subquery #807
Comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I noted some systems ignore order by in a from subquery or at least when it is not used with limit.
https://mariadb.com/kb/en/library/why-is-order-by-in-a-from-subquery-ignored/
Some more cases can benefit from it in addition to #759 mentioned by @Praveen2112
When outer query and inner query are both aggregation, it is hard to parallel outer query if we want to keep the ordering of inner query.
The text was updated successfully, but these errors were encountered: