Details
-
Improvement
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
We need to add next rules to planner
- FilterMergeRule
- FilterProjectTransposeRule
In order to be able to make this transformation for the query:
"select name from (\n" + " select *\n" + " from dept\n" + " where deptno = 10)\n" + "where deptno = 10\n" BEFORE= LogicalProject(NAME=[$1]) LogicalFilter(condition=[=(CAST($0):INTEGER, 10)]) LogicalProject(DEPTNO=[$0], NAME=[$1]) LogicalFilter(condition=[=(CAST($0):INTEGER, 10)]) IgniteTableScan(table=[[PUBLIC, DEPT]]) AFTER= IgniteProject(NAME=[$1]) IgniteProject(DEPTNO=[$0], NAME=[$1]) IgniteFilter(condition=[=(CAST($0):INTEGER, 10)]) IgniteTableScan(table=[[PUBLIC, DEPT]])
Attachments
Issue Links
- is part of
-
IGNITE-12248 Apache Calcite based query execution engine
- Open
- links to