diff options
| author | Amit Langote <amitlan@postgresql.org> | 2024-09-06 13:25:14 +0900 |
|---|---|---|
| committer | Amit Langote <amitlan@postgresql.org> | 2024-09-06 13:30:42 +0900 |
| commit | 446d5ad7ae7d3bf4fd08904ae54a6399cafb4e7d (patch) | |
| tree | 205cb0f2e3ae314723a17a35b9f06cc81e4b48a7 /src/backend/utils/adt/ruleutils.c | |
| parent | cd680b39211c5c3c88a143abcac576a22f996d7a (diff) | |
| download | postgresql-446d5ad7ae7d3bf4fd08904ae54a6399cafb4e7d.tar.gz postgresql-446d5ad7ae7d3bf4fd08904ae54a6399cafb4e7d.zip | |
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: https://postgr.es/m/CACJufxEo4sUjKCYtda0_qt9tazqqKPmF1cqhW9KBOUeJFqQd2g@mail.gmail.com
Backpatch-through: 17
Diffstat (limited to 'src/backend/utils/adt/ruleutils.c')
| -rw-r--r-- | src/backend/utils/adt/ruleutils.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/backend/utils/adt/ruleutils.c b/src/backend/utils/adt/ruleutils.c index 371b46e7a2d..cd9c3eddd1d 100644 --- a/src/backend/utils/adt/ruleutils.c +++ b/src/backend/utils/adt/ruleutils.c @@ -11875,7 +11875,7 @@ get_json_table(TableFunc *tf, deparse_context *context, bool showimplicit) get_json_table_columns(tf, castNode(JsonTablePathScan, tf->plan), context, showimplicit); - if (jexpr->on_error->btype != JSON_BEHAVIOR_EMPTY) + if (jexpr->on_error->btype != JSON_BEHAVIOR_EMPTY_ARRAY) get_json_behavior(jexpr->on_error, context, "ERROR"); if (PRETTY_INDENT(context)) |