[teiid-issues] [JBoss JIRA] (TEIID-5374) Allow for non-virtual dependent joins to be created over unions

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-5374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-5374.
-----------------------------------
    Fix Version/s: 10.3.2
                   10.2.3
       Resolution: Done


Corrected the issue with cost based union dependent join planning and the regression with TEIID-5020.  Applied to 10.3 and 10.2 as well since it's possible for the regression to introduce incorrect results.

> Allow for non-virtual dependent joins to be created over unions 
> ----------------------------------------------------------------
>
>                 Key: TEIID-5374
>                 URL: https://issues.jboss.org/browse/TEIID-5374
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 11.0, 10.3.2, 10.2.3
>
>
> A simple structure like:
> {code}
> join
>   access 
>   union
>     access
>     access
> {code}
> will reject creating a cost based dependent join over the union if the number of independent values seems too large for a virtual dependent join.
> A related issue is that TEIID-5020 introduced a regression when creating a dependent join that is eventually pushed over a union below an access node:
> {code}
> dependent select
>    access
>       set op
>         ..
> {code}
> the logic attempts to move nested dependent select back above the access node - so that only a single dependent predicate exists - based upon the node that is created at a child.  However if the child projects a literal into the dependent set criteria, then the result is invalid.



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