Details
-
Bug
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
10.1.3.3, 10.2.2.0, 10.3.3.1, 10.4.2.1, 10.5.3.1, 10.6.1.0
-
None
-
Normal
-
Repro attached
Description
The following query shows the error using the Derby demo toursDB:
SELECT FLIGHT_ID , SEGMENT_NUMBER , ARRIVE_TIME
FROM (
(SELECT HW.FLIGHT_ID , HW.SEGMENT_NUMBER , HW.ARRIVE_TIME FROM FLIGHTS HW)
UNION
(SELECT SW.FLIGHT_ID , SW.SEGMENT_NUMBER , SW.ARRIVE_TIME FROM FLIGHTS SW)
) SRC;
ERROR 42X01: Syntax error: Encountered "UNION" at line 4, column 12.
The following query works:
SELECT FLIGHT_ID , SEGMENT_NUMBER , ARRIVE_TIME
FROM (
SELECT HW.FLIGHT_ID , HW.SEGMENT_NUMBER , HW.ARRIVE_TIME FROM FLIGHTS HW
UNION
SELECT SW.FLIGHT_ID , SW.SEGMENT_NUMBER , SW.ARRIVE_TIME FROM FLIGHTS SW
) SRC;