[
https://issues.apache.org/jira/browse/CALCITE-4779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17417249#comment-17417249
]
Xurenhe edited comment on CALCITE-4779 at 9/18/21, 11:03 PM:
-------------------------------------------------------------
Hi [~xzh_dz] [~julianhyde]
For current case.
I add `CoreRules.AGGREGATE_PROJECT_PULL_UP_CONSTANTS` to canonicalize query,
it's passed.
!image-2021-09-19-06-41-52-352.png|width=579,height=312!
----
was (Author: wojustme):
Hi [~xzh_dz] [~julianhyde]
For current case.
I add `CoreRules.AGGREGATE_PROJECT_PULL_UP_CONSTANTS` to canonicalize query,
it's passed.
!image-2021-09-19-06-41-52-352.png!
> 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
> Priority: Major
> Attachments: image-2021-09-19-06-41-52-352.png
>
>
> {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)
