git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Only allow returning string types or bytea from json_serialize

author Andrew Dunstan <andrew@dunslane.net>

Thu, 7 Jul 2022 21:40:02 +0000 (17:40 -0400)

committer Andrew Dunstan <andrew@dunslane.net>

Thu, 7 Jul 2022 21:40:02 +0000 (17:40 -0400)

commit 3c633f32b9c712cc0b4c8d946f0eeae04a3ff51a

tree 5d95561130e6e77e0a7240f86cb5ea739c5a80be tree

parent 88210542106de5b26fe6aa088d1811b68502d224 commit | diff

Only allow returning string types or bytea from json_serialize

These are documented to be the allowed types for the RETURNING clause,
but the restriction was not being enforced, which caused a segfault if
another type was specified. Add some testing for this.

Per report from a.kozhemyakin

Backpatch to release 15.

src/backend/parser/parse_expr.c diff | blob | blame | history

src/test/regress/expected/sqljson.out diff | blob | blame | history

src/test/regress/sql/sqljson.sql diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom