pgsql: Fix restriction on specifying KEEP QUOTES in JSON_QUERY() - Mailing list pgsql-committers

From Amit Langote
Subject pgsql: Fix restriction on specifying KEEP QUOTES in JSON_QUERY()
Date
Msg-id E1rtjE5-0015U7-0J@gemulon.postgresql.org
Whole thread Raw
List 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(-)


pgsql-committers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: pgsql: Enhance libpq encryption negotiation tests with new GUC
Next
From: Alexander Korotkov
Date:
Subject: Re: pgsql: Transform OR clauses to ANY expression