[teiid-issues] [JBoss JIRA] (TEIID-5765) Criteria Pushdown is not working on FULL OUTER JOIN
Dmitrii Pogorelov created TEIID-5765:
----------------------------------------
Summary: 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
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)