]> granicus.if.org Git - postgresql/commit
Fix partial aggregation for variance(int4) and related aggregates.
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 21 Jun 2018 20:18:34 +0000 (16:18 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 21 Jun 2018 20:18:34 +0000 (16:18 -0400)
commitb8a1d0302063a8adbfe3f4c43ee457fe724be42a
treeff3566069a48b2941de59602863639340c6bd0b0
parenta4c95b0b80c70677c09c0d5c82a6fba875160288
Fix partial aggregation for variance(int4) and related aggregates.

A typo in numeric_poly_combine caused bogus results for queries using
it, but of course would only manifest if parallel aggregation is
performed.  Reported by Rajkumar Raghuwanshi.

David Rowley did the diagnosis and the fix; I editorialized rather
heavily on his regression test additions.

Back-patch to v10 where the breakage was introduced (by 9cca11c91).

Discussion: https://postgr.es/m/CAKcux6nU4E2x8nkSBpLOT2DPvQ5LviJ3SGyAN6Sz7qDH4G4+Pw@mail.gmail.com
src/backend/utils/adt/numeric.c
src/test/regress/expected/aggregates.out
src/test/regress/sql/aggregates.sql