Xurenhe created CALCITE-4857:
--------------------------------
Summary: Materialization-Failed, query could be grouping mv's
agg-call, when executing mv-match.
Key: CALCITE-4857
URL: https://issues.apache.org/jira/browse/CALCITE-4857
Project: Calcite
Issue Type: Bug
Reporter: Xurenhe
Here, query could be rewritten by mv, but it's failed now.
{code:java}
-- mv:
select deptno, salary, min(commission) as commission_min
from emps
group by deptno, salary
-- query:
select deptno, salary, max(salary), min(commission)
from emps
group by deptno, salary
-- after mv match
select deptno, salary, max(salary), commission_min
from mv
group by deptno, salary, commission_min
{code}
!image-2021-10-18-11-16-31-023.png!
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
