[teiid-issues] [JBoss JIRA] (TEIID-5109) Set operations and parenthesis
Mike Higgins (JIRA)
issues at jboss.org
Thu Oct 19 17:24:00 EDT 2017
Mike Higgins created TEIID-5109:
-----------------------------------
Summary: Set operations and parenthesis
Key: TEIID-5109
URL: https://issues.jboss.org/browse/TEIID-5109
Project: Teiid
Issue Type: Bug
Reporter: Mike Higgins
Assignee: Steven Hawkins
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)
More information about the teiid-issues
mailing list