pgsql: Fix two-argument jsonb_object when called with empty arrays - Mailing list pgsql-committers

From Andrew Dunstan
Subject pgsql: Fix two-argument jsonb_object when called with empty arrays
Date
Msg-id E1aXW9K-0003gf-TA@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix two-argument jsonb_object when called with empty arrays

Some over-eager copy-and-pasting on my part resulted in a nonsense
result being returned in this case. I have adopted the same pattern for
handling this case as is used in the one argument form of the function,
i.e. we just skip over the code that adds values to the object.

Diagnosis and patch from Michael Paquier, although not quite his
solution.

Fixes bug #13936.

Backpatch to 9.5 where jsonb_object was introduced.

Branch
------
REL9_5_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/68d68ff8333c106962d4a936e07eba24d63a2e07

Modified Files
--------------
src/backend/utils/adt/jsonb.c       |  7 ++++---
src/test/regress/expected/json.out  | 14 ++++++++++++++
src/test/regress/expected/jsonb.out | 14 ++++++++++++++
src/test/regress/sql/json.sql       |  6 ++++++
src/test/regress/sql/jsonb.sql      |  6 ++++++
5 files changed, 44 insertions(+), 3 deletions(-)


pgsql-committers by date:

Previous
From: Robert Haas
Date:
Subject: pgsql: Fix incorrect decision about which lock to take.
Next
From: Tom Lane
Date:
Subject: pgsql: Cosmetic improvements in new config_info code.