[jira] [Created] (CALCITE-6715) Enhance RelFieldTrimmer to trim LogicalCorrelate nodes

["Zoltan Haindrich (Jira)" <ji...@apache.org>]

Zoltan Haindrich created CALCITE-6715:
-----------------------------------------

             Summary: Enhance RelFieldTrimmer to trim LogicalCorrelate nodes
                 Key: CALCITE-6715
                 URL: https://issues.apache.org/jira/browse/CALCITE-6715
             Project: Calcite
          Issue Type: Improvement
            Reporter: Zoltan Haindrich
            Assignee: Zoltan Haindrich


Could enable the removal of irrelevant expressions below `LogcialCorrelate` expressions:

In the following plan {{$f8=[+($0, $0)]}} is completely unused; so it should be removed:
{code}
LogicalAggregate(group=[{1}], agg#0=[MAX($0)])
  LogicalCorrelate(correlation=[$cor0], joinType=[left], requiredColumns=[{7}])
    LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], ..., DEPTNO=[$7], $f8=[+($0, $0)])
      LogicalTableScan(table=[[scott, EMP]])
    LogicalFilter(condition=[=($0, +(10, $cor0.DEPTNO))])
      LogicalTableScan(table=[[scott, DEPT]])
{code}




--
This message was sent by Atlassian Jira
(v8.20.10#820010)