[ 
https://issues.apache.org/jira/browse/CALCITE-4030?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17119317#comment-17119317
 ] 

Rui Wang commented on CALCITE-4030:
-----------------------------------

All tests are affected by this JIRA (until the time when I logged this JIRA):

SortRemoveRuleTest. removeSortOverEnumerableHashJoin()
SortRemoveRuleTest. removeSortOverEnumerableNestedLoopJoin()
SortRemoveRuleTest. removeSortOverEnumerableSemiJoin()
MaterializedViewRelOptRulesTest. 
testJoinAggregateMaterializationAggregateFuncs11()
MaterializedViewRelOptRulesTest. 
testJoinAggregateMaterializationNoAggregateFuncs7()
MaterializedViewRelOptRulesTest. 
testJoinAggregateMaterializationNoAggregateFuncs9()
MaterializedViewRelOptRulesTest. testJoinMaterialization10()
MaterializedViewRelOptRulesTest. testJoinMaterialization12()
MaterializedViewRelOptRulesTest. testJoinMaterializationUKFK5()
MaterializedViewRelOptRulesTest. testJoinMaterializationUKFK6()

> Assert error during top-down optimization with Project/Filter Traits passdown 
> and derivation 
> ---------------------------------------------------------------------------------------------
>
>                 Key: CALCITE-4030
>                 URL: https://issues.apache.org/jira/browse/CALCITE-4030
>             Project: Calcite
>          Issue Type: Task
>            Reporter: Rui Wang
>            Priority: Major
>
> For example, with https://github.com/apache/calcite/pull/1985, and enable 
> top-down opt by set "calcite.planner.topdown.opt=true" in saffron.properties, 
> run test case SortRemoveRuleTest.removeSortOverEnumerableHashJoin, we can see:
> {code:java}
> java.lang.AssertionError
>       at 
> org.apache.calcite.plan.volcano.OptimizeTask$RelNodeOptTask.execute(OptimizeTask.java:232)
>       at 
> org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:553)
>       at 
> org.apache.calcite.tools.Programs$RuleSetProgram.run(Programs.java:327)
>       at 
> org.apache.calcite.prepare.PlannerImpl.transform(PlannerImpl.java:362)
>       at 
> org.apache.calcite.rel.rules.SortRemoveRuleTest.transform(SortRemoveRuleTest.java:77)
>       at 
> org.apache.calcite.rel.rules.SortRemoveRuleTest.removeSortOverEnumerableHashJoin(SortRemoveRuleTest.java:102)
> {code}
> The short term workaround is to comment the assert at OptimizeTask.java:232.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to