[
https://issues.apache.org/jira/browse/CALCITE-731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau updated CALCITE-731:
-----------------------------------
Fix Version/s: 1.4.0-incubating
> Incorrect results from GROUPING SETS
> ------------------------------------
>
> Key: CALCITE-731
> URL: https://issues.apache.org/jira/browse/CALCITE-731
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
> Fix For: 1.4.0-incubating
>
>
> Queries with GROUPING SETS do not seem to be returning grand totals. For
> example, using the schema of CALCITE-729, {noformat}> 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){noformat}
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
