Jesus Camacho Rodriguez created CALCITE-4499:
------------------------------------------------
Summary: FilterJoinRule misses opportunity to push filter to
semijoin input
Key: CALCITE-4499
URL: https://issues.apache.org/jira/browse/CALCITE-4499
Project: Calcite
Issue Type: Improvement
Components: core
Reporter: Jesus Camacho Rodriguez
Assignee: Jesus Camacho Rodriguez
Consider the following plan:
{code}
LogicalProject(DNAME=[$1])
LogicalJoin(condition=[AND(=($0, $10), =($8, 100))], joinType=[semi])
LogicalTableScan(table=[[scott, DEPT]])
LogicalTableScan(table=[[scott, EMP]])
{code}
The second conjunct only refers to columns from the right input, thus it could
be pushed to the right input. However, {{FilterJoinRule}} misses this
opportunity.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
