Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
The error comes in the following query:
SELECT * FROM (SELECT * FROM srcpart a WHERE a.ds = '2008-04-08' AND a.hr = '11' ORDER BY a.key LIMIT 5 UNION ALL SELECT * FROM srcpart b WHERE b.ds = '2008-04-08' AND b.hr = '14' ORDER BY b.key LIMIT 5) subq ORDER BY KEY LIMIT 5
But the following query works:
SELECT * FROM (SELECT * FROM (SELECT * FROM srcpart a WHERE a.ds = '2008-04-08' AND a.hr = '11' ORDER BY a.key LIMIT 5) pa UNION ALL SELECT * FROM (SELECT * FROM srcpart b WHERE b.ds = '2008-04-08' AND b.hr = '14' ORDER BY b.key LIMIT 5) pb) subq ORDER BY KEY LIMIT 5
The queries are logically identical, the query that's rejected has dummy select * clauses around the sub-queries.