db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kenneth Gee (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2374) UNION PROBLEM WITH PARENTHESIS
Date Sat, 24 Feb 2007 00:09:05 GMT
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.


Mime
View raw message