xzh_dz created CALCITE-4296: ------------------------------- Summary: Materialization recognition fail, cannot match Calc on top of materialized view Key: CALCITE-4296 URL: https://issues.apache.org/jira/browse/CALCITE-4296 Project: Calcite Issue Type: Wish Reporter: xzh_dz
MaterializedViewSubstitutionVisitorTest {code:java} // code placeholder @Test void test() { String mv = "" + "select sum(\"salary\"), \"deptno\"\n" + "from \"emps\"\n" + "group by \"deptno\""; String query = "" + "select \"deptno\"\n" + "from \"emps\"\n" + "group by \"deptno\""; sql(mv, query).ok(); } {code} exception: {code:java} // code placeholder java.lang.AssertionError: Materialized view failed to be matched by optimized results:java.lang.AssertionError: Materialized view failed to be matched by optimized results: at org.apache.calcite.test.AbstractMaterializedViewTest.checkMaterialize(AbstractMaterializedViewTest.java:112) at org.apache.calcite.test.AbstractMaterializedViewTest.access$000(AbstractMaterializedViewTest.java:64) at org.apache.calcite.test.AbstractMaterializedViewTest$Sql.ok(AbstractMaterializedViewTest.java:226) at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627) at org.apache.calcite.util.ImmutableBeans.lambda$makeDef$3(ImmutableBeans.java:291) at org.apache.calcite.util.ImmutableBeans$BeanImpl.invoke(ImmutableBeans.java:481) at com.sun.proxy.$Proxy12.ok(Unknown Source) {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)