[CALCITE-4857] Materialization-Failed, query could be grouping mv's agg-call, when executing mv-match.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: pull-request-available
• Assignee: Xurenhe
• Reporter: Xurenhe
• Created: 18/Oct/21 03:17
• Updated: 25/Jan/22 06:36

Description

Here, query could be rewritten by mv, but it's failed now.

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

 

 

 

Issue Links

• links to: GitHub Pull Request #2588
• links to: PR