[jira] [Created] (CALCITE-4499) FilterJoinRule misses opportunity to push filter to semijoin input

["Jesus Camacho Rodriguez (Jira)" <ji...@apache.org>]

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)