[
https://issues.apache.org/jira/browse/CALCITE-3918?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17087315#comment-17087315
]
Haisheng Yuan commented on CALCITE-3918:
----------------------------------------
Modify the code and return the relnode directly without decorrelating in
RelDecorrelator.
> 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
> Priority: Major
>
> 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)
