Only allow returning string types or bytea from json_serialize
authorAndrew Dunstan <[email protected]>
Thu, 7 Jul 2022 21:40:02 +0000 (17:40 -0400)
committerAndrew Dunstan <[email protected]>
Thu, 7 Jul 2022 21:40:02 +0000 (17:40 -0400)
commit3c633f32b9c712cc0b4c8d946f0eeae04a3ff51a
tree5d95561130e6e77e0a7240f86cb5ea739c5a80be
parent88210542106de5b26fe6aa088d1811b68502d224
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

Back to release 15.
src/backend/parser/parse_expr.c
src/test/regress/expected/sqljson.out
src/test/regress/sql/sqljson.sql