Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
-
2019-04
Description
We do not support ORDER BY within subqueries that are unioned, for example:
SELECT * FROM |
((SELECT a, b FROM t1 ORDER BY b LIMIT 2) sq1 |
UNION ALL |
(SELECT a, b FROM t2 ORDER BY b LIMIT 2) sq2) |
ORDER BY 1,2; |