Details
-
Type:
New Feature
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.2.4
-
Component/s: None
-
Labels:None
-
Sprint: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; |