]> granicus.if.org Git - postgresql/commit
Fix AggGetAggref() so it won't lie to aggregate final functions.
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 12 Oct 2017 19:20:04 +0000 (15:20 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 12 Oct 2017 19:20:04 +0000 (15:20 -0400)
commitaa1e9b3a466102fc43dc96906b9b3ced299ca7ed
tree1c117deabc3eef7ec3a11c14540839be44ac0b46
parent96cfc7e19ae1b70597a90487262cfb9f4531d846
Fix AggGetAggref() so it won't lie to aggregate final functions.

If we merge the transition calculations for two different aggregates,
it's reasonable to assume that the transition function should not care
which of those Aggref structs it gets from AggGetAggref().  It is not
reasonable to make the same assumption about an aggregate final function,
however.  Commit 804163bc2 broke this, as it will pass whichever Aggref
was first associated with the transition state in both cases.

This doesn't create an observable bug so far as the core system is
concerned, because the only existing uses of AggGetAggref() are in
ordered-set aggregates that happen to not pay attention to anything
but the input properties of the Aggref; and besides that, we disabled
sharing of transition calculations for OSAs yesterday.  Nonetheless,
if some third-party code were using AggGetAggref() in a normal aggregate,
they would be entitled to call this a bug.  Hence, back-patch the fix
to 9.6 where the problem was introduced.

In passing, improve some of the comments about transition state sharing.

Discussion: https://postgr.es/m/CAB4ELO5RZhOamuT9Xsf72ozbenDLLXZKSk07FiSVsuJNZB861A@mail.gmail.com
src/backend/executor/nodeAgg.c
src/include/nodes/execnodes.h