[ https://issues.apache.org/jira/browse/CALCITE-1652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15879012#comment-15879012 ]
Julian Hyde commented on CALCITE-1652: -------------------------------------- You're right. I was mistaken. GROUPING (and GROUPING_ID) accepts 1 or more arguments. > Allow GROUPING to have multiple arguments, like GROUPING_ID > ----------------------------------------------------------- > > Key: CALCITE-1652 > URL: https://issues.apache.org/jira/browse/CALCITE-1652 > Project: Calcite > Issue Type: Bug > Reporter: Julian Hyde > Assignee: Julian Hyde > > When initially added to the SQL standard {{GROUPING}} took one argument, a > column reference. Now it can have multiple arguments, like the > {{GROUPING_ID}} function. > In SQL standard 2014, see section 6.9 <set function specification>, and > feature T433, "Multiargument GROUPING function". > This change would extend {{GROUPING}} to allow one or more arguments (i.e. > what {{GROUPING_ID}} currently does), and make {{GROUPING_ID}} a synonym for > {{GROUPING}}. {{GROUP_ID}} is not affected, and continues to take zero > arguments. -- This message was sent by Atlassian JIRA (v6.3.15#6346)