On 2015-07-17 11:37:26 +0530, Jeevan Chalke wrote:
> However I wonder why we are supporting GROUPING SETS inside GROUPING SETS.
> On Oracle, it is throwing an error.
> We are not trying to be Oracle compatible, but just curious to know.
The SQL specification seems to be pretty unambigous about supporting
nested grouping set specifications. Check 7.9 <group by
clause>: <grouping set> (nested inside a <grouping sets specification>)
can contain <grouping sets specification>.
Regards,
Andres