xzh_dz created CALCITE-4779: ------------------------------- Summary: GroupSet contains constant, materialized view recognition failed Key: CALCITE-4779 URL: https://issues.apache.org/jira/browse/CALCITE-4779 Project: Calcite Issue Type: Improvement Reporter: xzh_dz
{code:java} // code placeholder org.apache.calcite.test.MaterializedViewSubstitutionVisitorTest @Test void testCountDistinct() { final String mv = "" + "select \"deptno\", \"empid\"\n" + "from \"emps\"\n" + "group by \"deptno\", \"empid\""; final String query = "" + "select 1, \"deptno\"\n" + "from \"emps\"\n" + "group by 1, \"deptno\""; sql(mv, query).ok(); } {code} Materialized view failed to be matched by optimized results: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:116) at org.apache.calcite.test.AbstractMaterializedViewTest.access$000(AbstractMaterializedViewTest.java:67) at org.apache.calcite.test.AbstractMaterializedViewTest$Sql.ok(AbstractMaterializedViewTest.java:229) at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627) -- This message was sent by Atlassian Jira (v8.3.4#803005)