pgsql: Fix crash in json{b}_populate_recordset() andjson{b}_to_records - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Fix crash in json{b}_populate_recordset() andjson{b}_to_records
Date
Msg-id E1fe2cs-000500-QY@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix crash in json{b}_populate_recordset() and json{b}_to_recordset().

As of commit 37a795a60, populate_recordset_worker() tried to pass back
(as rsi.setDesc) a tupdesc that it also had cached in its fn_extra.
But the core executor would free the passed-back tupdesc, risking a
crash if the function were called again in the same query.  The safest
and least invasive way to fix that is to make an extra tupdesc copy
to pass back.

While at it, I failed to resist the temptation to get rid of unnecessary
get_fn_expr_argtype() calls here and in populate_record_worker().

Per report from Dmitry Dolgov; thanks to Michael Paquier and
Andrew Gierth for investigation and discussion.

Discussion: https://postgr.es/m/CA+q6zcWzN9ztCfR47ZwgTr1KLnuO6BAY6FurxXhovP4hxr+yOQ@mail.gmail.com

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/9a5e8ed283e583782b3f40e6ededcb005d5c0333

Modified Files
--------------
src/backend/utils/adt/jsonfuncs.c   | 58 ++++++++++++++++++++++---------------
src/test/regress/expected/json.out  | 10 +++++++
src/test/regress/expected/jsonb.out | 10 +++++++
src/test/regress/sql/json.sql       |  2 ++
src/test/regress/sql/jsonb.sql      |  2 ++
5 files changed, 59 insertions(+), 23 deletions(-)


pgsql-committers by date:

Previous
From: Alvaro Herrera
Date:
Subject: pgsql: Dump foreign keys on partitioned tables
Next
From: Peter Eisentraut
Date:
Subject: pgsql: Update documentation editor setup instructions