Fix partial aggregation for the case of a degenerate GROUP BY clause.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: e1b449bea909fa70211841d508cfaf91d18a6abb
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2016-11-10T16:31:56Z
Releases: 10.0
Fix partial aggregation for the case of a degenerate GROUP BY clause.

The plan generated for sorted partial aggregation with "GROUP BY constant"
included a Sort node with no sort keys, which the executor does not like.

Per report from Steve Randall.  I'd add a regression test case if I could
think of a compact one, but it doesn't seem worth expending lots of cycles
on.

Report: <CABVd52UAdGXpg_rCk46egpNKYdXOzCjuJ1zG26E2xBe_8bj+Fg@mail.gmail.com>

Files

PathChange+/−
src/backend/optimizer/plan/planner.c modified +4 −4