Обсуждение: pgsql: Fix JSON aggregates to work properly when final function is re-e

Поиск
Список
Период
Сортировка

pgsql: Fix JSON aggregates to work properly when final function is re-e

От
Tom Lane
Дата:
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.

Branch
------
REL9_4_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/f0eeba6f83ed16687d8743b34e519de45c3915ec

Modified Files
--------------
src/backend/utils/adt/json.c |   45 +++++++++++++++++++++++++++++++-----------
1 file changed, 34 insertions(+), 11 deletions(-)