[CALCITE-731] Incorrect results from GROUPING SETS

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Fix Version/s: 1.4.0-incubating
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 15/May/15 20:08
• Updated: 02/Sep/15 01:05
• Resolved: 15/May/15 22:00

Description

Queries with GROUPING SETS do not seem to be returning grand totals. For example, using the schema of CALCITE-729,

> select grouping(deptno), deptno, loc from scott_clone.dept group by grouping sets (deptno), (loc);
+------------+--------+---------------+
|   EXPR$0   | DEPTNO |      LOC      |
+------------+--------+---------------+
| 1          | 10     | NEW YORK      |
| 1          | 30     | CHICAGO       |
| 1          | 40     | BOSTON        |
| 1          | 20     | DALLAS        |
+------------+--------+---------------+
4 rows selected (0.079 seconds)

There should be a row which gives the grand total for all DEPTNO values, and a row which gives the grand total for all LOC values.