Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
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:
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]])
Attachments
Issue Links
- links to