UNION PROBLEM WITH PARENTHESIS
------------------------------
Key: DERBY-2374
URL: https://issues.apache.org/jira/browse/DERBY-2374
Project: Derby
Issue Type: Bug
Affects Versions: 10.2.2.0
Reporter: Kenneth Gee
Priority: Minor
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;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
