]> granicus.if.org Git - postgresql/commit
Repair crash with unsortable data in grouping sets.
authorAndrew Gierth <rhodiumtoad@postgresql.org>
Mon, 24 Apr 2017 06:53:05 +0000 (07:53 +0100)
committerAndrew Gierth <rhodiumtoad@postgresql.org>
Mon, 24 Apr 2017 06:53:05 +0000 (07:53 +0100)
commit7be3678a8cfb55dcfca90fa586485f835ab912a5
tree4b068b169e45b3eed835302c1b5fb1831293df5a
parent81ff04deda21e016e0e1d4ea1755ccb14c47c871
Repair crash with unsortable data in grouping sets.

Previously the code would generate incorrect results, assertion
failures, or crashes if given unsortable (but hashable) columns in
grouping sets.  Handle by throwing an error instead.

Report and patch by Pavan Deolasee (though I changed the error
wording slightly); regression test by me.

(This affects 9.5 only since the planner was refactored in 9.6.)
src/backend/optimizer/plan/planner.c
src/test/regress/expected/groupingsets.out
src/test/regress/sql/groupingsets.sql