[DERBY-2374] UNION PROBLEM WITH PARENTHESIS

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.1.3.3, 10.2.2.0, 10.3.3.1, 10.4.2.1, 10.5.3.1, 10.6.1.0
• Component/s: SQL
• Labels: derby_triage10_5_2
• Urgency: Normal
• Issue & fix info: Repro attached
• Assignee: Unassigned
• Reporter: Kenneth Gee
• Created: 24/Feb/07 00:08
• Updated: 15/Feb/11 21:08

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;