Fix treatment of nulls in jsonb_agg and jsonb_object_agg
Andrew Dunstan <andrew@dunslane.net>
Fix treatment of nulls in jsonb_agg and jsonb_object_agg The wrong is_null flag was being passed to datum_to_json. Also, null object key values are not permitted, and this was not being checked for. Add regression tests covering these cases, and also add those tests to the json set, even though it was doing the right thing. Fixes bug #13514, initially diagnosed by Tom Lane.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/utils/adt/jsonb.c | modified | +9 −3 |
| src/test/regress/expected/json_1.out | modified | +20 −1 |
| src/test/regress/expected/jsonb_1.out | modified | +18 −1 |
| src/test/regress/expected/jsonb.out | modified | +18 −1 |
| src/test/regress/expected/json.out | modified | +20 −1 |
| src/test/regress/sql/jsonb.sql | modified | +11 −1 |
| src/test/regress/sql/json.sql | modified | +11 −2 |