pgsql: SQL/JSON: Fix default ON ERROR behavior for JSON_TABLE

Started by Amit Langotealmost 2 years ago1 messagescomitters

Langote_Amit_f8@lab.ntt.co.jp

almost 2 years ago

SQL/JSON: Fix default ON ERROR behavior for JSON_TABLE

Use EMPTY ARRAY instead of EMPTY.

This change does not affect the runtime behavior of JSON_TABLE(),
which continues to return an empty relation ON ERROR. It only alters
whether the default ON ERROR behavior is shown in the deparsed output.

Reported-by: Jian He <jian.universality@gmail.com>
Discussion: /messages/by-id/CACJufxEo4sUjKCYtda0_qt9tazqqKPmF1cqhW9KBOUeJFqQd2g@mail.gmail.com
Backpatch-through: 17

Branch
------
REL_17_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/5067c230b8ee42a01cc77dc5745bc3a78f393af3

Modified Files
--------------
src/backend/parser/parse_expr.c | 4 ++--
src/backend/utils/adt/ruleutils.c | 2 +-
src/test/regress/expected/sqljson_jsontable.out | 25 +++++++++++++++++++++++++
src/test/regress/sql/sqljson_jsontable.sql | 5 +++++
4 files changed, 33 insertions(+), 3 deletions(-)