]> 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:53:13 +0000 (16:53 +0200)
commitb17ae36ba9521014c5ae30cb3a3f77c439b41bb3
treeaab5e7f6b25e2818bca7d2a34cdbc35df4f89a90
parent29e4455d7139d0b1bf8d3b62e566e7bb20cf0ec6
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