[ 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)