[teiid-issues] [JBoss JIRA] (TEIID-5765) Criteria Pushdown is not working on FULL OUTER JOIN

Steven Hawkins (Jira) issues at jboss.org
Tue Jun 11 10:17:01 EDT 2019


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

Steven Hawkins resolved TEIID-5765.
-----------------------------------
    Fix Version/s: 12.3
                   12.1.2
                   12.2.1
       Resolution: Done


The check in rule push criteria after the join optimization is too broad - it was checking for any outer join.  So the change was just a sanity check of a full outer join.

> Criteria Pushdown is not working on FULL OUTER JOIN
> ---------------------------------------------------
>
>                 Key: TEIID-5765
>                 URL: https://issues.jboss.org/browse/TEIID-5765
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 12.0
>         Environment: teiid-12.0.0 on WildFly Full 14.0.1.Final (WildFly Core 6.0.2.Final)
>            Reporter: Dmitrii Pogorelov
>            Assignee: Steven Hawkins
>            Priority: Blocker
>             Fix For: 12.3, 12.1.2, 12.2.1
>
>
> Criteria Pushdown is not working on FULL OUTER JOIN (according to query plan criteria is not pushed down at all, it's in criteria of LEFT OUTER JOIN node):
> {code:noformat}
> ----------------------------------------------------------------------------
> OPTIMIZATION COMPLETE:
> PROCESSOR PLAN:
> ProjectNode(0) output=[1] [1]
>   SelectNode(1) output=[a.a] a.a = 1
>     JoinNode(2) [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [LEFT OUTER JOIN] criteria=[a.a=b.b] output=[a.a]
>       AccessNode(3) output=[a.a] SELECT g_0.a AS c_0 FROM test.test_a AS g_0 ORDER BY c_0
>       AccessNode(4) output=[b.b] SELECT g_0.b AS c_0 FROM dwh_my.test_a AS g_0 ORDER BY c_0
> {code}



--
This message was sent by Atlassian Jira
(v7.12.1#712002)


More information about the teiid-issues mailing list