[
https://issues.apache.org/jira/browse/CALCITE-4909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17450851#comment-17450851
]
Julian Hyde commented on CALCITE-4909:
--------------------------------------
What do you mean "there is a calc"? Do you mean there is a {{Calc}} RelNode?
Can you format your code example using JIRA's 'code' tag. Better still, explain
in English which is the query, and which is the materialized view definition,
and why you think it should match.
> In SubstituteVisitor, if there is a calc on target's agg, the query will not
> be rewritten by materialized view.
> ---------------------------------------------------------------------------------------------------------------
>
> Key: CALCITE-4909
> URL: https://issues.apache.org/jira/browse/CALCITE-4909
> Project: Calcite
> Issue Type: Improvement
> Reporter: Ziwei Liu
> Assignee: Ziwei Liu
> Priority: Major
>
> sql("select 'a',\"empid\",\"deptno\",sum(\"salary\") as s from \"emps\" group
> by \"empid\",\"deptno\"", "select sum(\"salary\") +1 as s,\"deptno\" from
> \"emps\" group by \"deptno\"").noMat();
> In substitute processing, this case will not be rewritten by materialized
> view because there is a calc on target's agg. We may need a rule
> AggregateOnCalcToCalcOnAggregateUnifyRule to handle this condition.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
