pgsql: Fix restriction on specifying KEEP QUOTES in JSON_QUERY()

From: Amit Langote <amitlan(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix restriction on specifying KEEP QUOTES in JSON_QUERY()
Date: 2024-04-08 07:15:33
Message-ID: E1rtjE5-0015U7-0J@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix restriction on specifying KEEP QUOTES in JSON_QUERY()

Currently, transformJsonFuncExpr() enforces some restrictions on
the combinations of QUOTES and WRAPPER clauses that can be specified
in JSON_QUERY(). The intent was to only prevent the useless
combination WITH WRAPPER OMIT QUOTES, but the coding prevented KEEP
QUOTES too, which is not helpful. Fix that.

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/561b74ddb8781f8c0511f6473c51fb51c8c6b087

Modified Files
--------------
src/backend/parser/parse_expr.c | 2 +-
src/test/regress/expected/sqljson_jsontable.out | 13 +++++----
src/test/regress/expected/sqljson_queryfuncs.out | 36 +++++++++++++++---------
src/test/regress/sql/sqljson_jsontable.sql | 5 ++--
src/test/regress/sql/sqljson_queryfuncs.sql | 11 ++++----
5 files changed, 41 insertions(+), 26 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Alexander Korotkov 2024-04-08 07:36:15 Re: pgsql: Transform OR clauses to ANY expression
Previous Message Kyotaro Horiguchi 2024-04-08 06:40:10 Re: pgsql: Enhance libpq encryption negotiation tests with new GUC