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)
