Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
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
Attachments
Attachments
Issue Links
- links to