[jira] [Created] (CALCITE-4909) In SubstituteVisitor, if there is a calc on target's agg, the query will not be rewritten by materialized view.

["Ziwei Liu (Jira)" <ji...@apache.org>]

Ziwei Liu created CALCITE-4909:
----------------------------------

             Summary: 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


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)