[
https://issues.apache.org/jira/browse/CALCITE-4045?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17126644#comment-17126644
]
Feng Zhu commented on CALCITE-4045:
-----------------------------------
Hi, [~jamie12221] thanks for reporting this issue. Could you provide the sql or
a complete test case?
> ReduceExpressionsRule$JoinReduceExpressionsRule(java.lang.IndexOutOfBoundsException:
> Index: 0, Size: 0)
> --------------------------------------------------------------------------------------------------------
>
> Key: CALCITE-4045
> URL: https://issues.apache.org/jira/browse/CALCITE-4045
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.23.0
> Reporter: jamie12221
> Priority: Trivial
>
> {code:java}
> [DEBUG] EXPLAIN select (select c.id from db1.company as c where c.id = t.id
> limit 0 ,10000) from db1.travelrecord as t where t.id = 1 LIMIT 500 ,10000
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.sql.parser toTree at
> 641]-[DEBUG] Reduced `c`.`id` = `t`.`id`
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.sql.parser toTree at
> 641]-[DEBUG] Reduced `t`.`id` = 1
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.sql2rel convertQuery at
> 581]-[DEBUG] Plan after converting SqlNode to RelNode
> LogicalSort(offset=[500], fetch=[10000])
> LogicalProject(EXPR$0=[$6])
> LogicalCorrelate(correlation=[$cor0], joinType=[left],
> requiredColumns=[{0}])
> LogicalFilter(condition=[=($0, 1)])
> LogicalTableScan(table=[[db1, travelrecord]])
> LogicalAggregate(group=[{}], agg#0=[SINGLE_VALUE($0)])
> LogicalSort(offset=[0], fetch=[10000])
> LogicalProject(id=[$0])
> LogicalFilter(condition=[=(CAST($0):BIGINT, $cor0.id)])
> LogicalTableScan(table=[[db1, company]])15:32:08
> T=noBindingExecutor2
> [org.apache.calcite.plan.AbstractRelOptPlanner.rule_execution_summary
> dumpRuleAttemptsInfo at 295]-[DEBUG] Rule Attempts Info for HepPlanner
> 15:32:08 T=noBindingExecutor2
> [org.apache.calcite.plan.AbstractRelOptPlanner.rule_execution_summary
> dumpRuleAttemptsInfo at 296]-[DEBUG]
> Rules
> Attempts Time (us)15:32:08 T=noBindingExecutor2
> [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final
> plan, using
> rel#266:LogicalSort.NONE.[](input=HepRelVertex#265,offset=500,fetch=10000)
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#264:LogicalProject.NONE.[](input=HepRelVertex#263,exprs=[$6])
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#262:LogicalCorrelate.NONE.[](left=HepRelVertex#252,right=HepRelVertex#261,correlation=$cor0,joinType=left,requiredColumns={0})
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#251:LogicalFilter.NONE.[](input=HepRelVertex#250,condition==(1, $0))
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#238:LogicalTableScan.NONE.[](table=[db1, travelrecord])
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#260:LogicalAggregate.NONE.[](input=HepRelVertex#259,group={},agg#0=SINGLE_VALUE($0))
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#258:LogicalSort.NONE.[](input=HepRelVertex#257,offset=0,fetch=10000)
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#256:LogicalProject.NONE.[](input=HepRelVertex#255,inputs=0)
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#254:LogicalFilter.NONE.[](input=HepRelVertex#253,condition==($cor0.id,
> CAST($0):BIGINT))
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#240:LogicalTableScan.NONE.[](table=[db1, company])
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.sql2rel decorrelateQuery at
> 210]-[DEBUG] Plan after removing Correlator
> LogicalSort(offset=[500], fetch=[10000])
> LogicalProject(EXPR$0=[$6])
> LogicalCorrelate(correlation=[$cor0], joinType=[left],
> requiredColumns=[{0}])
> LogicalFilter(condition=[=($0, 1)])
> LogicalTableScan(table=[[db1, travelrecord]])
> LogicalAggregate(group=[{}], agg#0=[SINGLE_VALUE($0)])
> LogicalSort(offset=[0], fetch=[10000])
> LogicalProject(id=[$0])
> LogicalFilter(condition=[=(CAST($0):BIGINT, $cor0.id)])
> LogicalTableScan(table=[[db1, company]])15:32:08
> T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner fireRule at
> 324]-[DEBUG] call#62: Apply rule [AdjustProjectForCountAggregateRule] to
> [rel#280:LogicalCorrelate.NONE.[](left=HepRelVertex#270,right=HepRelVertex#279,correlation=$cor0,joinType=left,requiredColumns={0}),
> rel#269:LogicalFilter.NONE.[](input=HepRelVertex#268,condition==(1, $0)),
> rel#278:LogicalAggregate.NONE.[](input=HepRelVertex#277,group={},agg#0=SINGLE_VALUE($0))]
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyTransformation at 364]-[DEBUG] call#62: Rule
> AdjustProjectForCountAggregateRule arguments
> [rel#280:LogicalCorrelate.NONE.[](left=HepRelVertex#270,right=HepRelVertex#279,correlation=$cor0,joinType=left,requiredColumns={0}),
> rel#269:LogicalFilter.NONE.[](input=HepRelVertex#268,condition==(1, $0)),
> rel#278:LogicalAggregate.NONE.[](input=HepRelVertex#277,group={},agg#0=SINGLE_VALUE($0))]
> produced rel#288:LogicalProject#288
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner fireRule
> at 324]-[DEBUG] call#63: Apply rule [AdjustProjectForCountAggregateRule] to
> [rel#291:LogicalCorrelate.NONE.[](left=HepRelVertex#289,right=HepRelVertex#290,correlation=$cor0,joinType=left,requiredColumns={0}),
> rel#269:LogicalFilter.NONE.[](input=HepRelVertex#268,condition==(1, $0)),
> rel#278:LogicalAggregate.NONE.[](input=HepRelVertex#277,group={},agg#0=SINGLE_VALUE($0))]
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner fireRule
> at 324]-[DEBUG] call#64: Apply rule [AdjustProjectForCountAggregateRule] to
> [rel#291:LogicalCorrelate.NONE.[](left=HepRelVertex#289,right=HepRelVertex#290,correlation=$cor0,joinType=left,requiredColumns={0}),
> rel#269:LogicalFilter.NONE.[](input=HepRelVertex#268,condition==(1, $0)),
> rel#278:LogicalAggregate.NONE.[](input=HepRelVertex#277,group={},agg#0=SINGLE_VALUE($0))]
> 15:32:08 T=noBindingExecutor2
> [org.apache.calcite.plan.AbstractRelOptPlanner.rule_execution_summary
> dumpRuleAttemptsInfo at 295]-[DEBUG] Rule Attempts Info for HepPlanner
> 15:32:08 T=noBindingExecutor2
> [org.apache.calcite.plan.AbstractRelOptPlanner.rule_execution_summary
> dumpRuleAttemptsInfo at 296]-[DEBUG]
> Rules
> Attempts Time (us)
> AdjustProjectForCountAggregateRule
> 3 7,17715:32:08 T=noBindingExecutor2
> [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final
> plan, using
> rel#284:LogicalSort.NONE.[](input=HepRelVertex#283,offset=500,fetch=10000)
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#282:LogicalProject.NONE.[](input=HepRelVertex#281,exprs=[$6])
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#293:LogicalProject.NONE.[](input=HepRelVertex#292,inputs=0..6)
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#291:LogicalCorrelate.NONE.[](left=HepRelVertex#289,right=HepRelVertex#290,correlation=$cor0,joinType=left,requiredColumns={0})
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#269:LogicalFilter.NONE.[](input=HepRelVertex#268,condition==(1, $0))
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#238:LogicalTableScan.NONE.[](table=[db1, travelrecord])
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#278:LogicalAggregate.NONE.[](input=HepRelVertex#277,group={},agg#0=SINGLE_VALUE($0))
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#276:LogicalSort.NONE.[](input=HepRelVertex#275,offset=0,fetch=10000)
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#274:LogicalProject.NONE.[](input=HepRelVertex#273,inputs=0)
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#272:LogicalFilter.NONE.[](input=HepRelVertex#271,condition==($cor0.id,
> CAST($0):BIGINT))
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#240:LogicalTableScan.NONE.[](table=[db1, company])
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner fireRule
> at 324]-[DEBUG] call#65: Apply rule [FilterJoinRule:FilterJoinRule:no-filter]
> to
> [rel#324:LogicalJoin.NONE.[](left=HepRelVertex#310,right=HepRelVertex#323,condition==($0,
> $6),joinType=left)]
> 15:32:08 T=noBindingExecutor2
> [org.apache.calcite.plan.AbstractRelOptPlanner.rule_execution_summary
> dumpRuleAttemptsInfo at 295]-[DEBUG] Rule Attempts Info for HepPlanner
> 15:32:08 T=noBindingExecutor2
> [org.apache.calcite.plan.AbstractRelOptPlanner.rule_execution_summary
> dumpRuleAttemptsInfo at 296]-[DEBUG]
> Rules
> Attempts Time (us)
> FilterJoinRule:FilterJoinRule:no-filter
> 1 1,04315:32:08 T=noBindingExecutor2
> [org.apache.calcite.plan.RelOptPlanner notifyChosen at 386]-[DEBUG] For final
> plan, using
> rel#328:LogicalSort.NONE.[](input=HepRelVertex#327,offset=500,fetch=10000)
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#326:LogicalProject.NONE.[](input=HepRelVertex#325,exprs=[$7])
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#324:LogicalJoin.NONE.[](left=HepRelVertex#310,right=HepRelVertex#323,condition==($0,
> $6),joinType=left)
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#309:LogicalFilter.NONE.[](input=HepRelVertex#308,condition==(1, $0))
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#238:LogicalTableScan.NONE.[](table=[db1, travelrecord])
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#322:LogicalAggregate.NONE.[](input=HepRelVertex#321,group={0},agg#0=SINGLE_VALUE($1))
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#320:LogicalProject.NONE.[](input=HepRelVertex#319,exprs=[$1, $0])
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#318:LogicalSort.NONE.[](input=HepRelVertex#317,fetch=10000)
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#316:LogicalProject.NONE.[](input=HepRelVertex#315,inputs=0,exprs=[$3])
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#314:LogicalFilter.NONE.[](input=HepRelVertex#313,condition==($3,
> CAST($0):BIGINT))
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#312:LogicalProject.NONE.[](input=HepRelVertex#311,inputs=0..2,exprs=[CAST($0):BIGINT])
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner
> notifyChosen at 386]-[DEBUG] For final plan, using
> rel#240:LogicalTableScan.NONE.[](table=[db1, company])
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner fireRule
> at 324]-[DEBUG] call#66: Apply rule [ReduceExpressionsRule(Project)] to
> [rel#348:LogicalProject.NONE.[](input=HepRelVertex#347,exprs=[$7])]
> 15:32:08 T=noBindingExecutor2 [org.apache.calcite.plan.RelOptPlanner fireRule
> at 324]-[DEBUG] call#67: Apply rule [ReduceExpressionsRule(Join)] to
> [rel#346:LogicalJoin.NONE.[](left=HepRelVertex#332,right=HepRelVertex#345,condition==($0,
> $6),joinType=left)]
> {code}
>
> {code:java}
> java.lang.IndexOutOfBoundsException: Index: 0, Size:
> 0java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 at
> java.util.ArrayList.rangeCheck(ArrayList.java:657) at
> java.util.ArrayList.get(ArrayList.java:433) at
> org.apache.calcite.rel.rules.ReduceExpressionsRule$RexReplacer.visit(ReduceExpressionsRule.java:858)
> at
> org.apache.calcite.rel.rules.ReduceExpressionsRule$RexReplacer.visitInputRef(ReduceExpressionsRule.java:837)
> at
> org.apache.calcite.rel.rules.ReduceExpressionsRule$RexReplacer.visitInputRef(ReduceExpressionsRule.java:816)
> at org.apache.calcite.rex.RexInputRef.accept(RexInputRef.java:112) at
> org.apache.calcite.rex.RexShuttle.visitList(RexShuttle.java:159) at
> org.apache.calcite.rex.RexShuttle.visitCall(RexShuttle.java:111) at
> org.apache.calcite.rel.rules.ReduceExpressionsRule$RexReplacer.visitCall(ReduceExpressionsRule.java:849)
> at
> org.apache.calcite.rel.rules.ReduceExpressionsRule$RexReplacer.visitCall(ReduceExpressionsRule.java:816)
> at org.apache.calcite.rex.RexCall.accept(RexCall.java:288) at
> org.apache.calcite.rex.RexShuttle.apply(RexShuttle.java:287) at
> org.apache.calcite.rex.RexShuttle.mutate(RexShuttle.java:249) at
> org.apache.calcite.rel.rules.ReduceExpressionsRule.reduceExpressionsInternal(ReduceExpressionsRule.java:701)
> at
> org.apache.calcite.rel.rules.ReduceExpressionsRule.reduceExpressions(ReduceExpressionsRule.java:620)
> at
> org.apache.calcite.rel.rules.ReduceExpressionsRule$JoinReduceExpressionsRule.onMatch(ReduceExpressionsRule.java:347)
> at
> org.apache.calcite.plan.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:338)
> at org.apache.calcite.plan.hep.HepPlanner.applyRule(HepPlanner.java:540) at
> org.apache.calcite.plan.hep.HepPlanner.applyRules(HepPlanner.java:405) at
> org.apache.calcite.plan.hep.HepPlanner.executeInstruction(HepPlanner.java:270)
> at
> org.apache.calcite.plan.hep.HepInstruction$RuleCollection.execute(HepInstruction.java:74)
> at
> org.apache.calcite.plan.hep.HepPlanner.executeProgram(HepPlanner.java:201) at
> org.apache.calcite.plan.hep.HepPlanner.findBestExp(HepPlanner.java:188)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
