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

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13504196#comment-13504196 ] 

RH Bugzilla Integration commented on TEIID-5109:
------------------------------------------------

Van Halbert <vhalbert at redhat.com> changed the Status of [bug 1504707|https://bugzilla.redhat.com/show_bug.cgi?id=1504707] from MODIFIED to ON_QA

> Set operations and parenthesis
> ------------------------------
>
>                 Key: TEIID-5109
>                 URL: https://issues.jboss.org/browse/TEIID-5109
>             Project: Teiid
>          Issue Type: Bug
>          Components: Connector API, Query Engine
>            Reporter: Mike Higgins
>            Assignee: Steven Hawkins
>            Priority: Blocker
>             Fix For: 10.0, 8.12.x-6.4, 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)