[teiid-issues] [JBoss JIRA] (TEIID-5113) Set operations and parenthesis

[Van Halbert (JIRA)]

Van Halbert created TEIID-5113:
----------------------------------

             Summary: Set operations and parenthesis
                 Key: TEIID-5113
                 URL: https://issues.jboss.org/browse/TEIID-5113
             Project: Teiid
          Issue Type: Bug
          Components: Connector API, Query Engine
            Reporter: Van Halbert
            Assignee: Steven Hawkins
            Priority: Blocker
             Fix For: 10.0, 9.3.4, 9.2.7


Using Teiid 9.2.2 with postgresql, I issue a query structured like this:
 
(a
UNION ALL
b
UNION ALL
c)
INTERSECT
d
 
All queries are from a single database.
This query does not give back the expected result.

In the plan, I see the query printed with no parenthesis around the unions:
a UNION ALL b UNION ALL c INTERSECT d

This gives the same result as the query submitted with no parens in it (the intersect of c and d is unioned with a union b.

The expepeted result is to preserve the paren so that the intersect is performed against the union of all three tables.

As a note, using UNION instead of UNION ALL did not preserve the parens, either.
 



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)