Fix JSON aggregates to work properly when final function is re-executed.
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 2 Dec 2014 20:02:43 +0000 (15:02 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 2 Dec 2014 20:02:43 +0000 (15:02 -0500)
commit8571ecb24f57a3aefc412eaf775423f9e456e47f
tree2a6e82b8ce1959ad9624b88ebfb9406c3ae687cc
parent10b81fbdc56aecb07c7cfaa1a70da8c1ad70b37d
Fix JSON aggregates to work properly when final function is re-executed.

Davide S. reported that json_agg() sometimes produced multiple trailing
right brackets.  This turns out to be because json_agg_finalfn() attaches
the final right bracket, and was doing so by modifying the aggregate state
in-place.  That's verboten, though unfortunately it seems there's no way
for nodeAgg.c to check for such mistakes.

Fix that back to 9.3 where the broken code was introduced.  In 9.4 and
HEAD, likewise fix json_object_agg(), which had copied the erroneous logic.
Make some cosmetic cleanups as well.
src/backend/utils/adt/json.c