]> granicus.if.org Git - postgresql/commit
Fix flattening of nested grouping sets.
authorAndres Freund <andres@anarazel.de>
Sun, 26 Jul 2015 14:37:49 +0000 (16:37 +0200)
committerAndres Freund <andres@anarazel.de>
Sun, 26 Jul 2015 14:50:29 +0000 (16:50 +0200)
commitfaab14ecb8c1b4ea2bee3723d4fa04f47275abd3
tree7190afc8a2e788c3c1a59f4dac0d79424beabb43
parent61444bfb809d3a088a270a59f383af3d4cd157b0
Fix flattening of nested grouping sets.

Previously nested grouping set specifications accidentally weren't
flattened, but instead contained the nested specification as a element
in the outer list.

Fix this by, as actually documented in comments, concatenating the
nested set specification into the outer one. Also add tests to prevent
this from breaking again.

Author: Andrew Gierth, with tests from Jeevan Chalke
Reported-By: Jeevan Chalke
Discussion: CAM2+6=V5YvuxB+EyN4iH=GbD-XTA435TCNvnDFSD--YvXs+pww@mail.gmail.com
Backpatch: 9.5, where grouping sets were introduced
src/backend/parser/parse_clause.c
src/test/regress/expected/groupingsets.out
src/test/regress/sql/groupingsets.sql