[teiid-issues] [JBoss JIRA] (TEIID-4448) Multi-way join predicate inappropriately removed

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-4448.
-----------------------------------
    Resolution: Done


Updated the logic to only set as optional in case where the reduction was down to a simple predicate.

> Multi-way join predicate inappropriately removed
> ------------------------------------------------
>
>                 Key: TEIID-4448
>                 URL: https://issues.jboss.org/browse/TEIID-4448
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.7
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Blocker
>             Fix For: 9.1, 8.13.7, 9.0.5
>
>
> In a situation where copy criteria can work against a multi-way join predicate, such that the predicate is not pushed:
> t1.a = coalesce(t2.b, t3.c, t4.d) ... t1.a = t4.d
> The multi-way predicate can be marked as optional and removed.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)