Haisheng Yuan created CALCITE-3918:
--------------------------------------
Summary: SubQueryFilterRemoveRule failed to decorrelate subquery
for TPCH q17
Key: CALCITE-3918
URL: https://issues.apache.org/jira/browse/CALCITE-3918
Project: Calcite
Issue Type: Bug
Components: core
Reporter: Haisheng Yuan
Disable RelDecorrelator and run TpchTest.testQuery17(),
SubQueryFilterRemoveRule generates plan with Correlate, which is not expected.
{code:java}
EnumerableProject(AVG_YEARLY=[/($0, 7.0:DECIMAL(2, 1))])
EnumerableAggregate(group=[{}], agg#0=[SUM($2)])
EnumerableFilter(condition=[AND(=($3, $0), =(CAST($4):VARCHAR, 'Brand#13'),
=(CAST($5):VARCHAR, 'JUMBO CAN'), <($1, $6))])
EnumerableCorrelate(correlation=[$cor0], joinType=[left],
requiredColumns=[{3}])
EnumerableNestedLoopJoin(condition=[true], joinType=[inner])
EnumerableProject(L_PARTKEY=[$1], L_QUANTITY=[$4],
L_EXTENDEDPRICE=[$5])
EnumerableTableScan(table=[[TPCH_01, LINEITEM]])
EnumerableProject(P_PARTKEY=[$0], P_BRAND=[$3], P_CONTAINER=[$6])
EnumerableTableScan(table=[[TPCH_01, PART]])
EnumerableProject($f0=[*(0.2:DECIMAL(2, 1), CAST(/(CASE(=($1, 0),
null:JavaType(class java.lang.Long), $0), $1)):JavaType(class java.lang.Long))])
EnumerableAggregate(group=[{}], agg#0=[$SUM0($4)], agg#1=[COUNT($4)])
EnumerableFilter(condition=[=($1, $cor0.P_PARTKEY)])
EnumerableTableScan(table=[[TPCH_01, LINEITEM]])
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
