You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by jh...@apache.org on 2018/08/31 06:04:24 UTC
[2/3] calcite git commit: [CALCITE-2470] In RelBuilder,
project method should combine expressions if the underlying node is a
Project
http://git-wip-us.apache.org/repos/asf/calcite/blob/370e95ab/core/src/test/resources/org/apache/calcite/test/RelOptRulesTest.xml
----------------------------------------------------------------------
diff --git a/core/src/test/resources/org/apache/calcite/test/RelOptRulesTest.xml b/core/src/test/resources/org/apache/calcite/test/RelOptRulesTest.xml
index ee683c1..1824e51 100644
--- a/core/src/test/resources/org/apache/calcite/test/RelOptRulesTest.xml
+++ b/core/src/test/resources/org/apache/calcite/test/RelOptRulesTest.xml
@@ -185,10 +185,9 @@ window w as (partition by empno order by empno)]]>
</Resource>
<Resource name="planAfter">
<![CDATA[
-LogicalProject(EXPR$0=[$0], EXPR$1=[$0])
- LogicalProject($0=[$9])
- LogicalWindow(window#0=[window(partition {0} order by [0] range between UNBOUNDED PRECEDING and CURRENT ROW aggs [COUNT()])])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+LogicalProject(EXPR$0=[$9], EXPR$1=[$9])
+ LogicalWindow(window#0=[window(partition {0} order by [0] range between UNBOUNDED PRECEDING and CURRENT ROW aggs [COUNT()])])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
<Resource name="planBefore">
@@ -494,10 +493,8 @@ LogicalProject(EMPNO=[$0])
LogicalProject(DEPTNO=[$0])
LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
LogicalAggregate(group=[{0}], EXPR$0=[AVG($1)])
- LogicalProject(EMPNO=[$1], SAL=[$0])
- LogicalProject(SAL=[$1], EMPNO=[$0])
- LogicalProject(EMPNO=[$0], SAL=[$5])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(EMPNO=[$0], SAL=[$5])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
</TestCase>
@@ -520,14 +517,12 @@ LogicalFilter(condition=[=($cor0.DEPTNO, $7)])
<Resource name="planAfter">
<![CDATA[
LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
- LogicalJoin(condition=[=($7, $9)], joinType=[inner])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
- LogicalProject(DEPTNO=[$0], $f1=[true])
- LogicalAggregate(group=[{0}])
- LogicalProject(DEPTNO=[$1], i=[$0])
- LogicalProject(i=[true], DEPTNO=[$7])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalJoin(condition=[=($7, $9)], joinType=[inner])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(DEPTNO=[$0], $f1=[true])
+ LogicalAggregate(group=[{0}])
+ LogicalProject(DEPTNO=[$7], i=[true])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
<Resource name="planMid">
@@ -585,22 +580,19 @@ LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$
<Resource name="planAfter">
<![CDATA[
LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
- LogicalFilter(condition=[IS NULL($12)])
- LogicalJoin(condition=[=($2, $11)], joinType=[left])
- LogicalJoin(condition=[=($7, $9)], joinType=[inner])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
- LogicalProject(DEPTNO=[$0], $f1=[true])
- LogicalAggregate(group=[{0}])
- LogicalProject(DEPTNO=[$1], i=[$0])
- LogicalProject(i=[true], DEPTNO=[$7])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
- LogicalProject(JOB=[$0], $f1=[true])
+ LogicalFilter(condition=[IS NULL($12)])
+ LogicalJoin(condition=[=($2, $11)], joinType=[left])
+ LogicalJoin(condition=[=($7, $9)], joinType=[inner])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(DEPTNO=[$0], $f1=[true])
LogicalAggregate(group=[{0}])
- LogicalProject(JOB=[$1], i=[$0])
- LogicalProject(i=[true], JOB=[$2])
- LogicalFilter(condition=[=($5, 34)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(DEPTNO=[$7], i=[true])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(JOB=[$0], $f1=[true])
+ LogicalAggregate(group=[{0}])
+ LogicalProject(JOB=[$2], i=[true])
+ LogicalFilter(condition=[=($5, 34)])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
</TestCase>
@@ -646,20 +638,17 @@ LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$
<Resource name="planAfter">
<![CDATA[
LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
- LogicalJoin(condition=[=($7, $10)], joinType=[inner])
- LogicalJoin(condition=[=($2, $9)], joinType=[inner])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
- LogicalAggregate(group=[{0}])
- LogicalProject(JOB=[$0])
- LogicalProject(JOB=[$2])
- LogicalFilter(condition=[=($5, 34)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
- LogicalProject(DEPTNO=[$0], $f1=[true])
- LogicalAggregate(group=[{0}])
- LogicalProject(DEPTNO=[$1], i=[$0])
- LogicalProject(i=[true], DEPTNO=[$7])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalJoin(condition=[=($7, $10)], joinType=[inner])
+ LogicalJoin(condition=[=($2, $9)], joinType=[inner])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalAggregate(group=[{0}])
+ LogicalProject(JOB=[$2])
+ LogicalFilter(condition=[=($5, 34)])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(DEPTNO=[$0], $f1=[true])
+ LogicalAggregate(group=[{0}])
+ LogicalProject(DEPTNO=[$7], i=[true])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
</TestCase>
@@ -707,14 +696,13 @@ LogicalProject(SAL=[$5])
<Resource name="planAfter">
<![CDATA[
LogicalProject(SAL=[$5])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
- LogicalJoin(condition=[AND(=($1, $12), =($0, $11))], joinType=[inner])
- LogicalJoin(condition=[AND(=($2, $10), =($0, $9))], joinType=[inner])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
- LogicalProject(DEPTNO=[$0], NAME=[$1])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
- LogicalProject(EMPNO=[$0], ENAME=[$1])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalJoin(condition=[AND(=($1, $12), =($0, $11))], joinType=[inner])
+ LogicalJoin(condition=[AND(=($2, $10), =($0, $9))], joinType=[inner])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(DEPTNO=[$0], NAME=[$1])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalProject(EMPNO=[$0], ENAME=[$1])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
</TestCase>
@@ -1957,18 +1945,14 @@ LogicalMinus(all=[false])
</Resource>
<Resource name="planBefore">
<![CDATA[
-LogicalProject(EXPR$0=[+($0, $1)])
- LogicalProject(Z=[+($0, $1)], X=[$0])
- LogicalProject(X=[$0], Y=[$1])
- LogicalFilter(condition=[>(+($0, $1), 50)])
- LogicalValues(tuples=[[{ 10, 1 }, { 30, 3 }]])
+LogicalProject(EXPR$0=[+(+($0, $1), $0)])
+ LogicalFilter(condition=[>(+($0, $1), 50)])
+ LogicalValues(tuples=[[{ 10, 1 }, { 30, 3 }]])
]]>
</Resource>
<Resource name="planAfter">
<![CDATA[
-LogicalProject(EXPR$0=[+($0, $1)])
- LogicalProject(Z=[+($0, $1)], X=[$0])
- LogicalValues(tuples=[[]])
+LogicalValues(tuples=[[]])
]]>
</Resource>
</TestCase>
@@ -1981,11 +1965,9 @@ LogicalProject(EXPR$0=[+($0, $1)])
</Resource>
<Resource name="planBefore">
<![CDATA[
-LogicalProject(EXPR$0=[+($0, $1)])
- LogicalProject(Z=[+($0, $1)], X=[$0])
- LogicalProject(X=[$0], Y=[$1])
- LogicalFilter(condition=[>(+($0, $1), 50)])
- LogicalValues(tuples=[[{ 10, 1 }, { 30, 3 }]])
+LogicalProject(EXPR$0=[+(+($0, $1), $0)])
+ LogicalFilter(condition=[>(+($0, $1), 50)])
+ LogicalValues(tuples=[[{ 10, 1 }, { 30, 3 }]])
]]>
</Resource>
<Resource name="planAfter">
@@ -2212,16 +2194,14 @@ LogicalCalc(expr#0=[{inputs}], expr#1=['TABLE '], expr#2=['t'], U=[$t1],
</Resource>
<Resource name="planBefore">
<![CDATA[
-LogicalProject(EXPR$0=[CASE(IS NULL($1), IS NULL($0), =(CAST($1):INTEGER NOT NULL, $0))])
- LogicalProject(EXPR$0=[2], EXPR$1=[null])
- LogicalValues(tuples=[[{ 0 }]])
+LogicalProject(EXPR$0=[CASE(IS NULL(null), IS NULL(2), =(CAST(null):INTEGER NOT NULL, 2))])
+ LogicalValues(tuples=[[{ 0 }]])
]]>
</Resource>
<Resource name="planAfter">
<![CDATA[
LogicalProject(EXPR$0=[false])
- LogicalProject(EXPR$0=[2], EXPR$1=[null])
- LogicalValues(tuples=[[{ 0 }]])
+ LogicalValues(tuples=[[{ 0 }]])
]]>
</Resource>
</TestCase>
@@ -2701,17 +2681,15 @@ LogicalProject(SAL=[$5])
LogicalFilter(condition=[AND(=($7, 20), >($5, 1000))])
LogicalTableScan(table=[[CATALOG, SALES, EMPNULLABLES]])
LogicalAggregate(group=[{0, 1}])
- LogicalProject(SAL=[$0], SAL0=[$1])
- LogicalProject(SAL=[$5], SAL0=[$8])
- LogicalJoin(condition=[OR(=($8, $5), =($8, 4))], joinType=[inner])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], SLACKER=[$8])
+ LogicalProject(SAL=[$5], SAL0=[$8])
+ LogicalJoin(condition=[OR(=($8, $5), =($8, 4))], joinType=[inner])
+ LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], SLACKER=[$8])
+ LogicalFilter(condition=[AND(=($7, 20), >($5, 1000))])
+ LogicalTableScan(table=[[CATALOG, SALES, EMPNULLABLES]])
+ LogicalAggregate(group=[{0}])
+ LogicalProject(SAL=[$5])
LogicalFilter(condition=[AND(=($7, 20), >($5, 1000))])
LogicalTableScan(table=[[CATALOG, SALES, EMPNULLABLES]])
- LogicalAggregate(group=[{0}])
- LogicalProject(SAL=[$5])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], SLACKER=[$8])
- LogicalFilter(condition=[AND(=($7, 20), >($5, 1000))])
- LogicalTableScan(table=[[CATALOG, SALES, EMPNULLABLES]])
]]>
</Resource>
<Resource name="planAfter">
@@ -2724,17 +2702,15 @@ LogicalProject(SAL=[$5])
LogicalTableScan(table=[[CATALOG, SALES, EMPNULLABLES]])
LogicalFilter(condition=[AND(OR(IS NOT NULL($0), =($0, 4)), OR(=($0, $1), =($0, 4)), OR(IS NOT NULL($1), =($1, 4)))])
LogicalAggregate(group=[{0, 1}])
- LogicalProject(SAL=[$0], SAL0=[$1])
- LogicalProject(SAL=[$5], SAL0=[$8])
- LogicalJoin(condition=[OR(=($8, $5), =($8, 4))], joinType=[inner])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], SLACKER=[$8])
+ LogicalProject(SAL=[$5], SAL0=[$8])
+ LogicalJoin(condition=[OR(=($8, $5), =($8, 4))], joinType=[inner])
+ LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], SLACKER=[$8])
+ LogicalFilter(condition=[AND(=($7, 20), >($5, 1000))])
+ LogicalTableScan(table=[[CATALOG, SALES, EMPNULLABLES]])
+ LogicalAggregate(group=[{0}])
+ LogicalProject(SAL=[$5])
LogicalFilter(condition=[AND(=($7, 20), >($5, 1000))])
LogicalTableScan(table=[[CATALOG, SALES, EMPNULLABLES]])
- LogicalAggregate(group=[{0}])
- LogicalProject(SAL=[$5])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], SLACKER=[$8])
- LogicalFilter(condition=[AND(=($7, 20), >($5, 1000))])
- LogicalTableScan(table=[[CATALOG, SALES, EMPNULLABLES]])
]]>
</Resource>
</TestCase>
@@ -3066,13 +3042,12 @@ LogicalProject(EXPR$0=[CAST(/(SUM(+(+($1, *(2, $2)), *(3, $3))) OVER (PARTITION
</Resource>
<Resource name="planAfter">
<![CDATA[
-LogicalProject(EXPR$0=[CAST(/($0, $1)):INTEGER NOT NULL])
- LogicalProject($0=[$2], $1=[$3])
- LogicalWindow(window#0=[window(partition {0} order by [] range between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING aggs [SUM($1), COUNT($1)])])
- LogicalProject(DEPTNO=[$0], $1=[+(+($1, *(2, $2)), *(3, $3))])
- LogicalAggregate(group=[{0}], agg#0=[SUM($1)], agg#1=[MIN($2)], agg#2=[AVG($2)])
- LogicalProject(DEPTNO=[$7], SAL=[$5], EMPNO=[$0])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+LogicalProject(EXPR$0=[CAST(/($2, $3)):INTEGER NOT NULL])
+ LogicalWindow(window#0=[window(partition {0} order by [] range between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING aggs [SUM($1), COUNT($1)])])
+ LogicalProject(DEPTNO=[$0], $1=[+(+($1, *(2, $2)), *(3, $3))])
+ LogicalAggregate(group=[{0}], agg#0=[SUM($1)], agg#1=[MIN($2)], agg#2=[AVG($2)])
+ LogicalProject(DEPTNO=[$7], SAL=[$5], EMPNO=[$0])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
</TestCase>
@@ -3827,9 +3802,8 @@ LogicalAggregate(group=[{0, 1, 2}], groups=[[{0, 1, 2}, {0, 1}, {0}, {}]])
<![CDATA[
LogicalProject(DEPTNO=[$0], EXPR$1=[$2])
LogicalAggregate(group=[{0, 1}], EXPR$1=[MAX($2)])
- LogicalProject(DEPTNO=[$7], FOUR=[$9], MGR=[$3])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], FOUR=[4], TWO_PLUS_THREE=[+(2, 3)], DEPTNO42=[+($7, 42)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(DEPTNO=[$7], FOUR=[4], MGR=[$3])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
<Resource name="planAfter">
@@ -3850,9 +3824,8 @@ LogicalAggregate(group=[{0}], EXPR$1=[MAX($2)])
<![CDATA[
LogicalProject(DEPTNO=[$0], EXPR$1=[$2])
LogicalAggregate(group=[{0, 1}], EXPR$1=[MAX($2)])
- LogicalProject(DEPTNO=[$7], FOUR=[$9], ENAME=[$1])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], FOUR=[4], TWO_PLUS_THREE=[+(2, 3)], DEPTNO42=[+($7, 42)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(DEPTNO=[$7], FOUR=[4], ENAME=[$1])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
<Resource name="planAfter">
@@ -3873,9 +3846,8 @@ LogicalAggregate(group=[{0}], EXPR$1=[MAX($2)])
<![CDATA[
LogicalProject(DEPTNO=[$0], EXPR$1=[$4])
LogicalAggregate(group=[{0, 1, 2, 3}], EXPR$1=[MAX($4)])
- LogicalProject(DEPTNO=[$7], FOUR=[$9], TWO_PLUS_THREE=[$10], DEPTNO42=[$11], MGR=[$3])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], FOUR=[4], TWO_PLUS_THREE=[+(2, 3)], DEPTNO42=[+($7, 42)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(DEPTNO=[$7], FOUR=[4], TWO_PLUS_THREE=[+(2, 3)], DEPTNO42=[+($7, 42)], MGR=[$3])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
<Resource name="planAfter">
@@ -3897,9 +3869,8 @@ LogicalProject(DEPTNO=[$0], EXPR$1=[$2])
<![CDATA[
LogicalProject(DEPTNO=[$1], EXPR$1=[$2])
LogicalAggregate(group=[{0, 1}], EXPR$1=[MAX($2)])
- LogicalProject(FOUR=[$9], DEPTNO=[$7], MGR=[$3])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], FOUR=[4], TWO_PLUS_THREE=[+(2, 3)], DEPTNO42=[+($7, 42)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(FOUR=[4], DEPTNO=[$7], MGR=[$3])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
<Resource name="planAfter">
@@ -3921,8 +3892,7 @@ LogicalAggregate(group=[{1}], EXPR$1=[MAX($2)])
LogicalProject(DEPTNO=[$1], EXPR$1=[$2])
LogicalAggregate(group=[{0, 1}], EXPR$1=[MAX($2)])
LogicalProject($f0=[+(42, 24)], DEPTNO=[$7], MGR=[$3])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], FOUR=[4], TWO_PLUS_THREE=[+(2, 3)], DEPTNO42=[+($7, 42)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
<Resource name="planAfter">
@@ -3943,8 +3913,7 @@ LogicalAggregate(group=[{1}], EXPR$1=[MAX($2)])
<![CDATA[
LogicalAggregate(group=[{0, 1}], EXPR$2=[MAX($2)])
LogicalProject(EXPR$0=[4], EXPR$1=[+(2, 3)], MGR=[$3])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], FOUR=[4], TWO_PLUS_THREE=[+(2, 3)], DEPTNO42=[+($7, 42)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
<Resource name="planAfter">
@@ -3965,9 +3934,8 @@ LogicalProject(EXPR$0=[$0], EXPR$1=[+(2, 3)], EXPR$2=[$1])
<Resource name="planBefore">
<![CDATA[
LogicalAggregate(group=[{0, 1}], EXPR$2=[MAX($2)])
- LogicalProject(EXPR$0=[4], EXPR$1=[+(2, 3)], FIVE=[$11])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], FOUR=[4], TWO_PLUS_THREE=[+(2, 3)], FIVE=[5], DEPTNO42=[+($7, 42)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(EXPR$0=[4], EXPR$1=[+(2, 3)], FIVE=[5])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
<Resource name="planAfter">
@@ -3989,8 +3957,7 @@ LogicalProject(EXPR$0=[$0], EXPR$1=[+(2, 3)], EXPR$2=[$1])
<![CDATA[
LogicalAggregate(group=[{0, 1}], EXPR$2=[MAX($2)])
LogicalProject(EXPR$0=[4], EXPR$1=[+(2, 3)], $f2=[5])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], FOUR=[4], TWO_PLUS_THREE=[+(2, 3)], FIVE=[5], DEPTNO42=[+($7, 42)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
<Resource name="planAfter">
@@ -4011,12 +3978,10 @@ select 2, deptno, job from emp as e2]]>
<Resource name="planBefore">
<![CDATA[
LogicalUnion(all=[true])
- LogicalProject(EXPR$0=[2], DEPTNO=[$1], JOB=[$0])
- LogicalProject(JOB=[$2], DEPTNO=[$7])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
- LogicalProject(EXPR$0=[2], DEPTNO=[$1], JOB=[$0])
- LogicalProject(JOB=[$2], DEPTNO=[$7])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(EXPR$0=[2], DEPTNO=[$7], JOB=[$2])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(EXPR$0=[2], DEPTNO=[$7], JOB=[$2])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
<Resource name="planAfter">
@@ -4056,11 +4021,9 @@ select 2, 3 from emp as e2]]>
<![CDATA[
LogicalUnion(all=[true])
LogicalProject(EXPR$0=[2], EXPR$1=[3])
- LogicalProject(DUMMY=[0])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
LogicalProject(EXPR$0=[2], EXPR$1=[3])
- LogicalProject(DUMMY=[0])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
<Resource name="planAfter">
@@ -5094,29 +5057,25 @@ LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$
</Resource>
<Resource name="planBefore">
<![CDATA[
-LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], DEPTNO0=[$9], NAME=[$10])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], DEPTNO0=[$10], NAME=[$11])
- LogicalJoin(condition=[AND(=($0, $10), =($9, $12))], joinType=[inner])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], $f9=[+($7, $0)])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
- LogicalFilter(condition=[=($0, 10)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
- LogicalProject(DEPTNO=[$0], NAME=[$1], $f2=[+($0, 5)])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], DEPTNO0=[$10], NAME=[$11])
+ LogicalJoin(condition=[AND(=($0, $10), =($9, $12))], joinType=[inner])
+ LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], $f9=[+($7, $0)])
+ LogicalFilter(condition=[=($0, 10)])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(DEPTNO=[$0], NAME=[$1], $f2=[+($0, 5)])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
]]>
</Resource>
<Resource name="planAfter">
<![CDATA[
-LogicalProject(EMPNO=[10], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], DEPTNO0=[10], NAME=[$10])
- LogicalProject(EMPNO=[10], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], DEPTNO0=[10], NAME=[$11])
- LogicalJoin(condition=[=($9, 15)], joinType=[inner])
- LogicalProject(EMPNO=[10], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], $f9=[+($7, 10)])
- LogicalProject(EMPNO=[10], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
- LogicalFilter(condition=[=($0, 10)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
- LogicalProject(DEPTNO=[10], NAME=[$1], $f2=[15])
- LogicalFilter(condition=[=($0, 10)])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+LogicalProject(EMPNO=[10], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], DEPTNO0=[10], NAME=[$11])
+ LogicalJoin(condition=[=($9, 15)], joinType=[inner])
+ LogicalProject(EMPNO=[10], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], $f9=[+($7, 10)])
+ LogicalFilter(condition=[=($0, 10)])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(DEPTNO=[10], NAME=[$1], $f2=[15])
+ LogicalFilter(condition=[=($0, 10)])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
]]>
</Resource>
</TestCase>
@@ -5159,7 +5118,7 @@ LogicalProject(DEPTNO=[$0], NAME=[$1])
LogicalJoin(condition=[=($0, $2)], joinType=[inner])
LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
LogicalAggregate(group=[{0}])
- LogicalProject(DEPTNO9=[$7], $f0=[true])
+ LogicalProject(DEPTNO=[$7], $f0=[true])
LogicalFilter(condition=[>($5, 100)])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
@@ -5168,7 +5127,7 @@ LogicalProject(DEPTNO=[$0], NAME=[$1])
<![CDATA[
SemiJoin(condition=[=($0, $2)], joinType=[inner])
LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
- LogicalProject(DEPTNO9=[$7], $f0=[true])
+ LogicalProject(DEPTNO=[$7], $f0=[true])
LogicalFilter(condition=[>($5, 100)])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
@@ -5187,7 +5146,7 @@ LogicalProject(DEPTNO=[$0])
LogicalJoin(condition=[=($0, $2)], joinType=[inner])
SemiJoin(condition=[=($0, $2)], joinType=[inner])
LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
- LogicalProject(DEPTNO9=[$7], $f0=[true])
+ LogicalProject(DEPTNO=[$7], $f0=[true])
LogicalFilter(condition=[>($5, 100)])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
LogicalTableScan(table=[[CATALOG, CUSTOMER, ACCOUNT]])
@@ -5200,7 +5159,7 @@ LogicalProject(DEPTNO=[$0])
SemiJoin(condition=[=($0, $1)], joinType=[inner])
LogicalProject(DEPTNO=[$0])
LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
- LogicalProject(DEPTNO9=[$1])
+ LogicalProject(DEPTNO=[$1])
LogicalFilter(condition=[>($0, 100)])
LogicalProject(SAL=[$5], DEPTNO=[$7])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
@@ -5242,9 +5201,8 @@ group by x, y]]>
<![CDATA[
LogicalProject(X=[$0], EXPR$1=[$2], Y=[$1])
LogicalAggregate(group=[{0, 1}], EXPR$1=[SUM($2)])
- LogicalProject(X=[$0], Y=[$1], Z=[$2])
- LogicalProject(X=[$7], Y=[$0], Z=[$5], ZZ=[*($5, 2)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(X=[$7], Y=[$0], Z=[$5])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
<Resource name="planAfter">
@@ -5267,9 +5225,8 @@ group by rollup(x, y)]]>
<![CDATA[
LogicalProject(X=[$0], EXPR$1=[$2], Y=[$1])
LogicalAggregate(group=[{0, 1}], groups=[[{0, 1}, {0}, {}]], EXPR$1=[SUM($2)])
- LogicalProject(X=[$0], Y=[$1], Z=[$2])
- LogicalProject(X=[$7], Y=[$0], Z=[$5], ZZ=[*($5, 2)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(X=[$7], Y=[$0], Z=[$5])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
<Resource name="planAfter">
@@ -5341,11 +5298,10 @@ LogicalAggregate(group=[{0, 1}])
</Resource>
<Resource name="planAfter">
<![CDATA[
-LogicalProject(EXPR$0=[$1], DEPTNO=[$0])
- LogicalProject(DEPTNO=[$1], $1=[$2])
- LogicalWindow(window#0=[window(partition {} order by [] range between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING aggs [COUNT($0)])])
- LogicalProject(EMPNO=[$0], DEPTNO=[$7])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+LogicalProject(EXPR$0=[$2], DEPTNO=[$1])
+ LogicalWindow(window#0=[window(partition {} order by [] range between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING aggs [COUNT($0)])])
+ LogicalProject(EMPNO=[$0], DEPTNO=[$7])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
<Resource name="planBefore">
@@ -5366,18 +5322,16 @@ from (
</Resource>
<Resource name="planAfter">
<![CDATA[
-LogicalProject(COL1=[$2], COL2=[$3])
+LogicalProject($0=[$2], $1=[$3])
LogicalWindow(window#0=[window(partition {1} order by [0] range between UNBOUNDED PRECEDING and CURRENT ROW aggs [SUM($2), SUM($3)])])
- LogicalProject(SAL=[$1], DEPTNO=[$2])
- LogicalProject(EMPNO=[$0], SAL=[$5], DEPTNO=[$7])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(SAL=[$5], DEPTNO=[$7])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
<Resource name="planBefore">
<![CDATA[
-LogicalProject(COL1=[$1], COL2=[$2])
- LogicalProject(EMPNO=[$0], COL1=[SUM(100) OVER (PARTITION BY $7 ORDER BY $5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)], COL2=[SUM(1000) OVER (PARTITION BY $7 ORDER BY $5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+LogicalProject(COL1=[SUM(100) OVER (PARTITION BY $7 ORDER BY $5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)], COL2=[SUM(1000) OVER (PARTITION BY $7 ORDER BY $5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
</TestCase>
@@ -5681,14 +5635,16 @@ right join dept c on b.deptno > 10
</Resource>
<Resource name="planBefore">
<![CDATA[
-LogicalProject(NAME=[$1])
- LogicalJoin(condition=[$4], joinType=[right])
- LogicalProject(DEPTNO=[$0], NAME=[$1], DEPTNO0=[$2], NAME0=[$3], $f4=[>($2, 10)])
+LogicalProject(NAME=[$0])
+ LogicalJoin(condition=[$1], joinType=[right])
+ LogicalProject(NAME=[$1], $f4=[$5])
LogicalJoin(condition=[$4], joinType=[left])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
- LogicalProject(DEPTNO=[$0], NAME=[$1], $f2=[>($0, 10)])
+ LogicalProject(DEPTNO=[$0], NAME=[$1])
LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalProject(DEPTNO=[$0], NAME=[$1], $f2=[>($0, 10)], >=[>($0, 10)])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalProject(DEPTNO=[$0])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
]]>
</Resource>
<Resource name="planAfter">
@@ -5911,9 +5867,8 @@ group by e.job,d.name]]>
LogicalAggregate(group=[{2, 11}])
LogicalJoin(condition=[AND(=($2, $11), =($9, $12))], joinType=[inner])
LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], $f9=[+($7, $0)])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
- LogicalFilter(condition=[=($0, 10)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalFilter(condition=[=($0, 10)])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
LogicalProject(DEPTNO=[$0], NAME=[$1], $f2=[+($0, 5)])
LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
]]>
@@ -5924,9 +5879,8 @@ LogicalAggregate(group=[{0, 2}])
LogicalJoin(condition=[AND(=($0, $2), =($1, $3))], joinType=[inner])
LogicalAggregate(group=[{2, 9}])
LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], $f9=[+($7, $0)])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
- LogicalFilter(condition=[=($0, 10)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalFilter(condition=[=($0, 10)])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
LogicalAggregate(group=[{1, 2}])
LogicalProject(DEPTNO=[$0], NAME=[$1], $f2=[+($0, 5)])
LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
@@ -6095,15 +6049,14 @@ LogicalProject(JOB=[$0], EXPR$1=[$2])
<Resource name="planAfter">
<![CDATA[
LogicalProject(JOB=[$0], EXPR$1=[$2])
- LogicalProject(JOB=[$0], NAME=[$2], $f4=[$4])
- LogicalProject(JOB=[$0], EXPR$1=[$1], NAME=[$2], $f1=[$3], $f4=[CAST(*($1, $3)):INTEGER NOT NULL])
- LogicalJoin(condition=[=($0, $2)], joinType=[inner])
- LogicalAggregate(group=[{2}], EXPR$1=[SUM($5)])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
- LogicalFilter(condition=[=($0, 10)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
- LogicalAggregate(group=[{1}], agg#0=[COUNT()])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalProject(JOB=[$0], NAME=[$2], $f4=[CAST(*($1, $3)):INTEGER NOT NULL])
+ LogicalJoin(condition=[=($0, $2)], joinType=[inner])
+ LogicalAggregate(group=[{2}], EXPR$1=[SUM($5)])
+ LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
+ LogicalFilter(condition=[=($0, 10)])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalAggregate(group=[{1}], agg#0=[COUNT()])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
]]>
</Resource>
</TestCase>
@@ -6643,13 +6596,12 @@ LogicalProject(JOB=[$0], MIN_SAL=[$2], MIN_DEPTNO=[$3], SUM_SAL_PLUS=[+($4, 1)],
<Resource name="planAfter">
<![CDATA[
LogicalProject(JOB=[$0], MIN_SAL=[$2], MIN_DEPTNO=[$3], SUM_SAL_PLUS=[+($4, 1)], MAX_SAL=[$5], SUM_SAL_2=[$4], COUNT_SAL=[$6], COUNT_MGR=[$7])
- LogicalProject(JOB=[$0], NAME=[$7], MIN_SAL=[$1], MIN_DEPTNO=[$2], $f9=[$9], MAX_SAL=[$4], $f10=[$10], $f11=[$11])
- LogicalProject(JOB=[$0], MIN_SAL=[$1], MIN_DEPTNO=[$2], SUM_SAL_2=[$3], MAX_SAL=[$4], COUNT_SAL=[$5], COUNT_MGR=[$6], NAME=[$7], $f1=[$8], $f9=[CAST(*($3, $8)):INTEGER NOT NULL], $f10=[*($5, $8)], $f11=[*($6, $8)])
- LogicalJoin(condition=[=($0, $7)], joinType=[inner])
- LogicalAggregate(group=[{2}], MIN_SAL=[MIN($5)], MIN_DEPTNO=[MIN($7)], SUM_SAL_2=[SUM($5)], MAX_SAL=[MAX($5)], COUNT_SAL=[COUNT()], COUNT_MGR=[COUNT($3)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
- LogicalAggregate(group=[{1}], agg#0=[COUNT()])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalProject(JOB=[$0], NAME=[$7], MIN_SAL=[$1], MIN_DEPTNO=[$2], $f9=[CAST(*($3, $8)):INTEGER NOT NULL], MAX_SAL=[$4], $f10=[*($5, $8)], $f11=[*($6, $8)])
+ LogicalJoin(condition=[=($0, $7)], joinType=[inner])
+ LogicalAggregate(group=[{2}], MIN_SAL=[MIN($5)], MIN_DEPTNO=[MIN($7)], SUM_SAL_2=[SUM($5)], MAX_SAL=[MAX($5)], COUNT_SAL=[COUNT()], COUNT_MGR=[COUNT($3)])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalAggregate(group=[{1}], agg#0=[COUNT()])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
]]>
</Resource>
</TestCase>
@@ -7190,13 +7142,11 @@ LogicalSort(sort0=[$0], dir0=[ASC], fetch=[10])
LogicalSort(sort0=[$0], dir0=[ASC], fetch=[10])
LogicalUnion(all=[true])
LogicalSort(sort0=[$0], dir0=[ASC], fetch=[10])
- LogicalProject(NAME=[$0])
- LogicalProject(NAME=[$1])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalProject(NAME=[$1])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
LogicalSort(sort0=[$0], dir0=[ASC], fetch=[10])
- LogicalProject(NAME=[$0])
- LogicalProject(NAME=[$1])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalProject(NAME=[$1])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
]]>
</Resource>
</TestCase>
@@ -7222,10 +7172,9 @@ LogicalProject(EMPNO=[$0], D=[CASE(IS NOT NULL($10), true, false)])
LogicalJoin(condition=[=($7, $9)], joinType=[left])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
LogicalAggregate(group=[{0, 1}])
- LogicalProject(DEPTNO=[$0], i=[true])
- LogicalProject(DEPTNO=[$7])
- LogicalFilter(condition=[<($0, 20)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(DEPTNO=[$7], i=[true])
+ LogicalFilter(condition=[<($0, 20)])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
</TestCase>
@@ -7255,10 +7204,9 @@ LogicalProject(EMPNO=[$0])
LogicalFilter(condition=[OR(IS NOT NULL($11), <($5, 100))])
LogicalJoin(condition=[AND(=($0, $9), =($7, $10))], joinType=[left])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
- LogicalProject(EMPNO=[$0], DEPTNO=[$1], i=[true])
- LogicalProject(EMPNO=[$0], DEPTNO=[$7])
- LogicalFilter(condition=[<($0, 20)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(EMPNO=[$0], DEPTNO=[$7], i=[true])
+ LogicalFilter(condition=[<($0, 20)])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
</TestCase>
@@ -7321,10 +7269,9 @@ LogicalProject(EMPNO=[$0])
LogicalJoin(condition=[=($7, $9)], joinType=[left])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
LogicalAggregate(group=[{0, 1}])
- LogicalProject(DEPTNO=[$0], i=[true])
- LogicalProject(DEPTNO=[$7])
- LogicalFilter(condition=[<($0, 20)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(DEPTNO=[$7], i=[true])
+ LogicalFilter(condition=[<($0, 20)])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
</TestCase>
@@ -7483,10 +7430,9 @@ LogicalProject(EMPNO=[$0], DEPTNO=[$7])
LogicalProject(EMPNO=[$0], D=[CASE(IS NOT NULL($11), true, false)])
LogicalJoin(condition=[AND(=($0, $9), =($7, $10))], joinType=[left])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
- LogicalProject(EMPNO=[$0], DEPTNO=[$1], i=[true])
- LogicalProject(EMPNO=[$0], DEPTNO=[$7])
- LogicalFilter(condition=[<($0, 20)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(EMPNO=[$0], DEPTNO=[$7], i=[true])
+ LogicalFilter(condition=[<($0, 20)])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
</TestCase>
@@ -7689,13 +7635,11 @@ LogicalSort(sort0=[$0], dir0=[ASC])
LogicalSort(sort0=[$0], dir0=[ASC])
LogicalUnion(all=[true])
LogicalSort(sort0=[$0], dir0=[ASC])
- LogicalProject(NAME=[$0])
- LogicalProject(NAME=[$1])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalProject(NAME=[$1])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
LogicalSort(sort0=[$0], dir0=[ASC])
- LogicalProject(NAME=[$0])
- LogicalProject(NAME=[$1])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalProject(NAME=[$1])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
]]>
</Resource>
</TestCase>
@@ -7722,13 +7666,11 @@ LogicalSort(sort0=[$0], dir0=[ASC], fetch=[0])
LogicalSort(sort0=[$0], dir0=[ASC], fetch=[0])
LogicalUnion(all=[true])
LogicalSort(sort0=[$0], dir0=[ASC], fetch=[0])
- LogicalProject(NAME=[$0])
- LogicalProject(NAME=[$1])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalProject(NAME=[$1])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
LogicalSort(sort0=[$0], dir0=[ASC], fetch=[0])
- LogicalProject(NAME=[$0])
- LogicalProject(NAME=[$1])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalProject(NAME=[$1])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
]]>
</Resource>
</TestCase>
@@ -7826,34 +7768,31 @@ from e2]]>
</Resource>
<Resource name="planBefore">
<![CDATA[
-LogicalProject(EMPNO=[$0], D=[IN($1, {
+LogicalProject(EMPNO=[$0], D=[IN(CASE(true, CAST($7):INTEGER, null), {
LogicalProject(DEPTNO=[$1])
LogicalFilter(condition=[<($0, 20)])
LogicalProject(EMPNO=[$0], DEPTNO=[CASE(true, CAST($7):INTEGER, null)])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
})])
- LogicalProject(EMPNO=[$0], DEPTNO=[CASE(true, CAST($7):INTEGER, null)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
<Resource name="planAfter">
<![CDATA[
-LogicalProject(EMPNO=[$0], D=[CASE(=($2, 0), false, IS NULL($1), null, IS NOT NULL($5), true, <($3, $2), null, false)])
- LogicalJoin(condition=[=($1, $4)], joinType=[left])
+LogicalProject(EMPNO=[$0], D=[CASE(=($9, 0), false, IS NULL(CASE(true, CAST($7):INTEGER, null)), null, IS NOT NULL($12), true, <($10, $9), null, false)])
+ LogicalJoin(condition=[=(CAST($7):INTEGER, $11)], joinType=[left])
LogicalJoin(condition=[true], joinType=[inner])
- LogicalProject(EMPNO=[$0], DEPTNO=[CASE(true, CAST($7):INTEGER, null)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
LogicalAggregate(group=[{}], c=[COUNT()], ck=[COUNT($0)])
LogicalProject(DEPTNO=[$1])
LogicalFilter(condition=[<($0, 20)])
LogicalProject(EMPNO=[$0], DEPTNO=[CASE(true, CAST($7):INTEGER, null)])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
LogicalAggregate(group=[{0, 1}])
- LogicalProject(DEPTNO=[$0], i=[true])
- LogicalProject(DEPTNO=[$1])
- LogicalFilter(condition=[<($0, 20)])
- LogicalProject(EMPNO=[$0], DEPTNO=[CASE(true, CAST($7):INTEGER, null)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(DEPTNO=[$1], i=[true])
+ LogicalFilter(condition=[<($0, 20)])
+ LogicalProject(EMPNO=[$0], DEPTNO=[CASE(true, CAST($7):INTEGER, null)])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
</TestCase>
@@ -7897,10 +7836,9 @@ LogicalProject(EMPNO=[$0])
LogicalFilter(condition=[<($0, 20)])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
LogicalAggregate(group=[{0, 1}])
- LogicalProject(EXPR$0=[$0], i=[true])
- LogicalProject(EXPR$0=[CASE(true, CAST($7):INTEGER, null)])
- LogicalFilter(condition=[<($0, 20)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(EXPR$0=[CASE(true, CAST($7):INTEGER, null)], i=[true])
+ LogicalFilter(condition=[<($0, 20)])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
</TestCase>
@@ -8038,11 +7976,10 @@ LogicalProject(SAL=[$5])
<Resource name="planAfter">
<![CDATA[
LogicalProject(SAL=[$5])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
- LogicalJoin(condition=[AND(=($2, $10), =($0, $9))], joinType=[inner])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
- LogicalProject(DEPTNO=[$0], NAME=[$1])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalJoin(condition=[AND(=($2, $10), =($0, $9))], joinType=[inner])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(DEPTNO=[$0], NAME=[$1])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
]]>
</Resource>
</TestCase>
@@ -8238,16 +8175,14 @@ LogicalProject(ENAME=[$0])
<Resource name="planAfter">
<![CDATA[
LogicalProject(ENAME=[$0])
- LogicalProject(ENAME=[$0], DEPTNO=[$1], SALPLUS=[$2])
- LogicalJoin(condition=[AND(=($2, $4), =($1, $3))], joinType=[inner])
- LogicalProject(ENAME=[$1], DEPTNO=[$7], SALPLUS=[+($5, 1)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
- LogicalAggregate(group=[{0, 1}])
- LogicalProject(DEPTNO=[$0], $f9=[$1])
- LogicalProject(DEPTNO=[$7], $f9=[$9])
- LogicalFilter(condition=[=(+($5, 1), $9)])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], $f9=[+($5, 1)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalJoin(condition=[AND(=($2, $4), =($1, $3))], joinType=[inner])
+ LogicalProject(ENAME=[$1], DEPTNO=[$7], SALPLUS=[+($5, 1)])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalAggregate(group=[{0, 1}])
+ LogicalProject(DEPTNO=[$7], $f9=[$9])
+ LogicalFilter(condition=[=(+($5, 1), $9)])
+ LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], $f9=[+($5, 1)])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
</TestCase>
@@ -8287,16 +8222,14 @@ LogicalProject(NAME=[$0])
<Resource name="planAfter">
<![CDATA[
LogicalProject(NAME=[$0])
- LogicalProject(NAME=[$0], DEPTNO=[$1], DEPTNOMINUS=[$2])
- LogicalJoin(condition=[AND(=($2, $4), =($1, $3))], joinType=[inner])
- LogicalProject(NAME=[$1], DEPTNO=[$0], DEPTNOMINUS=[-($0, 10)])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
- LogicalAggregate(group=[{0, 1}])
- LogicalProject(DEPTNO=[$0], $f9=[$1])
- LogicalProject(DEPTNO=[$7], $f9=[$9])
- LogicalFilter(condition=[=(+($5, 1), $9)])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], $f9=[+($5, 1)])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalJoin(condition=[AND(=($2, $4), =($1, $3))], joinType=[inner])
+ LogicalProject(NAME=[$1], DEPTNO=[$0], DEPTNOMINUS=[-($0, 10)])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalAggregate(group=[{0, 1}])
+ LogicalProject(DEPTNO=[$7], $f9=[$9])
+ LogicalFilter(condition=[=(+($5, 1), $9)])
+ LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], $f9=[+($5, 1)])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
</TestCase>
@@ -8321,18 +8254,15 @@ LogicalProject(DEPTNO=[$0])
<Resource name="planAfter">
<![CDATA[
LogicalProject(SAL=[$5])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
- LogicalFilter(condition=[NOT(CASE(=($10, 0), false, IS NOT NULL($13), true, <($11, $10), true, false))])
- LogicalJoin(condition=[AND(=($0, $12), =($2, $14))], joinType=[left])
- LogicalJoin(condition=[=($2, $9)], joinType=[left])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
- LogicalAggregate(group=[{0}], c=[COUNT()], ck=[COUNT($1)])
- LogicalProject(NAME=[$1], DEPTNO=[$0])
- LogicalProject(DEPTNO=[$0], NAME=[$1])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
- LogicalProject(DEPTNO=[$0], i=[true], NAME=[$1])
- LogicalProject(DEPTNO=[$0], NAME=[$1])
+ LogicalFilter(condition=[NOT(CASE(=($10, 0), false, IS NOT NULL($13), true, <($11, $10), true, false))])
+ LogicalJoin(condition=[AND(=($0, $12), =($2, $14))], joinType=[left])
+ LogicalJoin(condition=[=($2, $9)], joinType=[left])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalAggregate(group=[{0}], c=[COUNT()], ck=[COUNT($1)])
+ LogicalProject(NAME=[$1], DEPTNO=[$0])
LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalProject(DEPTNO=[$0], i=[true], NAME=[$1])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
]]>
</Resource>
<Resource name="planMid">
@@ -8349,9 +8279,8 @@ LogicalProject(SAL=[$5])
LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
LogicalFilter(condition=[=($cor0.EMPNO, $0)])
LogicalProject(DEPTNO=[$0], i=[true])
- LogicalProject(DEPTNO=[$0])
- LogicalFilter(condition=[=($cor0.JOB, $1)])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalFilter(condition=[=($cor0.JOB, $1)])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
]]>
</Resource>
</TestCase>
@@ -8379,8 +8308,7 @@ LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$
LogicalJoin(condition=[=($0, $9)], joinType=[left])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
LogicalProject(DEPTNO=[$0], i=[true])
- LogicalProject(DEPTNO=[$0])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
]]>
</Resource>
<Resource name="planAfter">
@@ -8391,8 +8319,7 @@ LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$
LogicalJoin(condition=[=($0, $9)], joinType=[left])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
LogicalProject(DEPTNO=[$0], i=[true])
- LogicalProject(DEPTNO=[$0])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
]]>
</Resource>
</TestCase>
@@ -8429,40 +8356,34 @@ LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$
LogicalProject(ENAME=[$1], EMPNO=[$0], R=[$5])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
LogicalFilter(condition=[=($cor0.EMPNO, $0)])
- LogicalProject(EMPNO=[$0], i=[true])
- LogicalProject(EMPNO=[$1])
- LogicalFilter(condition=[AND(>($2, 2), =($cor0.ENAME, $0))])
- LogicalProject(ENAME=[$1], EMPNO=[$0], R=[$5])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(EMPNO=[$1], i=[true])
+ LogicalFilter(condition=[AND(>($2, 2), =($cor0.ENAME, $0))])
+ LogicalProject(ENAME=[$1], EMPNO=[$0], R=[$5])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
<Resource name="planAfter">
<![CDATA[
LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
- LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
- LogicalFilter(condition=[NOT(CASE(=($10, 0), false, IS NOT NULL($13), true, <($11, $10), true, false))])
- LogicalJoin(condition=[AND(=($0, $12), =($1, $14))], joinType=[left])
- LogicalJoin(condition=[=($1, $9)], joinType=[left])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
- LogicalAggregate(group=[{0}], c=[COUNT()], ck=[COUNT($1)])
- LogicalProject(ENAME=[$1], EMPNO=[$0])
- LogicalProject(EMPNO=[$1], ENAME=[$0])
- LogicalFilter(condition=[>($2, 2)])
- LogicalProject(ENAME=[$1], EMPNO=[$0], R=[$5])
- LogicalTableScan(table=[[CATALOG, SALES, EMP]])
- LogicalProject(EMPNO=[$0], i=[true], ENAME=[$1])
- LogicalProject(EMPNO=[$1], ENAME=[$0])
+ LogicalFilter(condition=[NOT(CASE(=($10, 0), false, IS NOT NULL($13), true, <($11, $10), true, false))])
+ LogicalJoin(condition=[AND(=($0, $12), =($1, $14))], joinType=[left])
+ LogicalJoin(condition=[=($1, $9)], joinType=[left])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalAggregate(group=[{0}], c=[COUNT()], ck=[COUNT($1)])
+ LogicalProject(ENAME=[$0], EMPNO=[$1])
LogicalFilter(condition=[>($2, 2)])
LogicalProject(ENAME=[$1], EMPNO=[$0], R=[$5])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
+ LogicalProject(EMPNO=[$1], i=[true], ENAME=[$0])
+ LogicalFilter(condition=[>($2, 2)])
+ LogicalProject(ENAME=[$1], EMPNO=[$0], R=[$5])
+ LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
</Resource>
</TestCase>
<TestCase name="testProjectCorrelateTransposeWithExprCond">
<Resource name="sql">
- <![CDATA[select t1.name, t2.ename
-from DEPT_NESTED as t1,
-unnest(t1.employees) as t2]]>
+ <![CDATA[select t1.name, t2.ename from DEPT_NESTED as t1, unnest(t1.employees) as t2]]>
</Resource>
<Resource name="planBefore">
<![CDATA[
@@ -8474,7 +8395,6 @@ LogicalProject(NAME=[$1], ENAME=[$5])
LogicalValues(tuples=[[{ 0 }]])
]]>
</Resource>
-
<Resource name="planAfter">
<![CDATA[
LogicalProject(NAME=[$0], ENAME=[$2])
@@ -8490,9 +8410,7 @@ LogicalProject(NAME=[$0], ENAME=[$2])
</TestCase>
<TestCase name="testProjectCorrelateTransposeDynamic">
<Resource name="sql">
- <![CDATA[select t1.c_nationkey, t2.fake_col2
-from SALES.CUSTOMER as t1,
-unnest(t1.fake_col) as t2]]>
+ <![CDATA[select t1.c_nationkey, t2.a as fake_col2 from SALES.CUSTOMER as t1, unnest(t1.fake_col) as t2(a)]]>
</Resource>
<Resource name="planBefore">
<![CDATA[
@@ -8519,9 +8437,7 @@ LogicalProject(C_NATIONKEY=[$1], FAKE_COL2=[$2])
</TestCase>
<TestCase name="testProjectCorrelateTranspose">
<Resource name="sql">
- <![CDATA[select t1.name, t2.ename
-from DEPT_NESTED as t1,
-unnest(t1.employees) as t2]]>
+ <![CDATA[select t1.name, t2.ename from DEPT_NESTED as t1, unnest(t1.employees) as t2]]>
</Resource>
<Resource name="planBefore">
<![CDATA[
@@ -8533,7 +8449,6 @@ LogicalProject(NAME=[$1], ENAME=[$5])
LogicalValues(tuples=[[{ 0 }]])
]]>
</Resource>
-
<Resource name="planAfter">
<![CDATA[
LogicalProject(NAME=[$0], ENAME=[$2])
@@ -8563,7 +8478,6 @@ LogicalProject(NAME=[$1], ENAME=[$5])
LogicalValues(tuples=[[{ 0 }]])
]]>
</Resource>
-
<Resource name="planAfter">
<![CDATA[
LogicalProject(NAME=[$0], ENAME=[$2])
@@ -8582,35 +8496,35 @@ LogicalProject(NAME=[$0], ENAME=[$2])
<![CDATA[
LogicalProject(EMPNO=[$0])
LogicalFilter(condition=[IS NOT NULL($9)])
- LogicalCorrelate(correlation=[$cor1], joinType=[left], requiredColumns=[{0, 7}])
+ LogicalCorrelate(correlation=[$cor0], joinType=[left], requiredColumns=[{7}])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
LogicalAggregate(group=[{}], agg#0=[MIN($0)])
LogicalProject($f0=[true])
- LogicalProject(EMPNO=[$cor1.EMPNO], DEPTNO=[$0])
- LogicalFilter(condition=[=($cor1.DEPTNO, $0)])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalFilter(condition=[=($cor0.DEPTNO, $0)])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
]]>
</Resource>
-
<Resource name="planAfter">
<![CDATA[
LogicalProject(EMPNO=[$0])
LogicalFilter(condition=[IS NOT NULL($1)])
LogicalProject(EMPNO=[$0], $f0=[$2])
- LogicalCorrelate(correlation=[$cor2], joinType=[left], requiredColumns=[{0, 1}])
+ LogicalCorrelate(correlation=[$cor2], joinType=[left], requiredColumns=[{1}])
LogicalProject(EMPNO=[$0], DEPTNO=[$7])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
LogicalProject($f0=[$0])
LogicalAggregate(group=[{}], agg#0=[MIN($0)])
LogicalProject($f0=[true])
- LogicalProject(EMPNO=[$cor2.EMPNO], DEPTNO=[$0])
- LogicalFilter(condition=[=($cor2.DEPTNO, $0)])
- LogicalProject(DEPTNO=[$0])
- LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
+ LogicalFilter(condition=[=($cor2.DEPTNO, $0)])
+ LogicalProject(DEPTNO=[$0])
+ LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
]]>
</Resource>
+ <Resource name="sql">
+ <![CDATA[SELECT e1.empno
+FROM emp e1 where exists (select empno, deptno from dept d2 where e1.deptno = d2.deptno)]]>
+ </Resource>
</TestCase>
-
<TestCase name="testProjectCorrelateTransposeRuleSemiCorrelate">
<Resource name="planAfter">
<![CDATA[
@@ -8623,7 +8537,6 @@ LogicalCorrelate(correlation=[$cor0], joinType=[semi], requiredColumns=[{0}])
]]>
</Resource>
</TestCase>
-
<TestCase name="testProjectCorrelateTransposeRuleAntiCorrelate">
<Resource name="planAfter">
<![CDATA[
@@ -8636,5 +8549,4 @@ LogicalCorrelate(correlation=[$cor0], joinType=[anti], requiredColumns=[{0}])
]]>
</Resource>
</TestCase>
-
</Root>