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

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)