Обсуждение: pgsql: Disallow invalid path elements in jsonb_set

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

pgsql: Disallow invalid path elements in jsonb_set

От
Andrew Dunstan
Дата:
Disallow invalid path elements in jsonb_set

Null path elements and, where the object is an array, invalid integer
elements now cause an error.

Incorrect behaviour noted by Thom Brown, patch from Dmitry Dolgov.

Backpatch to 9.5 where jsonb_set was introduced

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/1edd4ec831458e10b524d1473a7de5791aa8753e

Modified Files
--------------
src/backend/utils/adt/jsonfuncs.c     |    5 ++++-
src/test/regress/expected/jsonb.out   |   24 +++++++++---------------
src/test/regress/expected/jsonb_1.out |   24 +++++++++---------------
src/test/regress/sql/jsonb.sql        |    3 +++
4 files changed, 25 insertions(+), 31 deletions(-)