pgsql: Revert SQL/JSON features

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Revert SQL/JSON features
Date: 2022-09-01 21:13:27
Message-ID: E1oTrV9-000zTH-C0@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Revert SQL/JSON features

The reverts the following and makes some associated cleanups:

commit f79b803dc: Common SQL/JSON clauses
commit f4fb45d15: SQL/JSON constructors
commit 5f0adec25: Make STRING an unreserved_keyword.
commit 33a377608: IS JSON predicate
commit 1a36bc9db: SQL/JSON query functions
commit 606948b05: SQL JSON functions
commit 49082c2cc: RETURNING clause for JSON() and JSON_SCALAR()
commit 4e34747c8: JSON_TABLE
commit fadb48b00: PLAN clauses for JSON_TABLE
commit 2ef6f11b0: Reduce running time of jsonb_sqljson test
commit 14d3f24fa: Further improve jsonb_sqljson parallel test
commit a6baa4bad: Documentation for SQL/JSON features
commit b46bcf7a4: Improve readability of SQL/JSON documentation.
commit 112fdb352: Fix finalization for json_objectagg and friends
commit fcdb35c32: Fix transformJsonBehavior
commit 4cd8717af: Improve a couple of sql/json error messages
commit f7a605f63: Small cleanups in SQL/JSON code
commit 9c3d25e17: Fix JSON_OBJECTAGG uniquefying bug
commit a79153b7a: Claim SQL standard compliance for SQL/JSON features
commit a1e7616d6: Rework SQL/JSON documentation
commit 8d9f9634e: Fix errors in copyfuncs/equalfuncs support for JSON node types.
commit 3c633f32b: Only allow returning string types or bytea from json_serialize
commit 67b26703b: expression eval: Fix EEOP_JSON_CONSTRUCTOR and EEOP_JSONEXPR size.

The release notes are also adjusted.

Backpatch to release 15.

Discussion: https://postgr.es/m/40d2c882-bcac-19a9-754d-4299e1d87ac7@postgresql.org

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/96ef3237bf741c12390003e90a4d7115c0c854b7

Modified Files
--------------
doc/src/sgml/func.sgml | 1065 +-----------
doc/src/sgml/keywords/sql2016-02-reserved.txt | 1 -
doc/src/sgml/release-15.sgml | 93 --
src/backend/catalog/sql_features.txt | 30 +-
src/backend/commands/explain.c | 8 +-
src/backend/executor/execExpr.c | 359 +----
src/backend/executor/execExprInterp.c | 743 ---------
src/backend/executor/nodeTableFuncscan.c | 23 +-
src/backend/jit/llvm/llvmjit_expr.c | 18 -
src/backend/jit/llvm/llvmjit_types.c | 3 -
src/backend/nodes/copyfuncs.c | 566 -------
src/backend/nodes/equalfuncs.c | 442 -----
src/backend/nodes/makefuncs.c | 122 --
src/backend/nodes/nodeFuncs.c | 486 ------
src/backend/nodes/outfuncs.c | 175 --
src/backend/nodes/readfuncs.c | 213 ---
src/backend/optimizer/path/costsize.c | 3 +-
src/backend/optimizer/util/clauses.c | 78 -
src/backend/parser/Makefile | 1 -
src/backend/parser/gram.y | 1115 +------------
src/backend/parser/parse_clause.c | 12 +-
src/backend/parser/parse_collate.c | 7 -
src/backend/parser/parse_expr.c | 1502 -----------------
src/backend/parser/parse_jsontable.c | 732 ---------
src/backend/parser/parse_relation.c | 7 +-
src/backend/parser/parse_target.c | 40 -
src/backend/parser/parser.c | 16 -
src/backend/utils/adt/format_type.c | 4 -
src/backend/utils/adt/formatting.c | 45 +-
src/backend/utils/adt/json.c | 553 +------
src/backend/utils/adt/jsonb.c | 352 +---
src/backend/utils/adt/jsonb_util.c | 39 +-
src/backend/utils/adt/jsonfuncs.c | 71 +-
src/backend/utils/adt/jsonpath.c | 257 ---
src/backend/utils/adt/jsonpath_exec.c | 844 +---------
src/backend/utils/adt/ruleutils.c | 719 +--------
src/backend/utils/misc/queryjumble.c | 72 -
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_aggregate.dat | 22 -
src/include/catalog/pg_proc.dat | 74 -
src/include/executor/execExpr.h | 98 --
src/include/executor/executor.h | 2 -
src/include/nodes/makefuncs.h | 12 -
src/include/nodes/nodes.h | 28 -
src/include/nodes/parsenodes.h | 287 ----
src/include/nodes/primnodes.h | 265 +--
src/include/parser/kwlist.h | 26 -
src/include/parser/parse_clause.h | 3 -
src/include/utils/formatting.h | 4 -
src/include/utils/json.h | 26 -
src/include/utils/jsonb.h | 33 -
src/include/utils/jsonfuncs.h | 7 -
src/include/utils/jsonpath.h | 37 -
src/interfaces/ecpg/preproc/ecpg.trailer | 41 +-
src/interfaces/ecpg/preproc/parse.pl | 2 -
src/interfaces/ecpg/preproc/parser.c | 14 -
src/test/regress/expected/json_sqljson.out | 24 -
src/test/regress/expected/jsonb_sqljson.out | 2135 -------------------------
src/test/regress/expected/opr_sanity.out | 6 +-
src/test/regress/expected/sqljson.out | 1320 ---------------
src/test/regress/parallel_schedule | 2 +-
src/test/regress/sql/json_sqljson.sql | 15 -
src/test/regress/sql/jsonb_sqljson.sql | 977 -----------
src/test/regress/sql/opr_sanity.sql | 6 +-
src/test/regress/sql/sqljson.sql | 471 ------
src/tools/pgindent/typedefs.list | 15 -
66 files changed, 350 insertions(+), 16420 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2022-09-02 00:00:23 pgsql: Move darwin sysroot determination into separate file
Previous Message Tom Lane 2022-09-01 19:02:51 pgsql: Add a regression test for contrib/pgrowlocks.

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2022-09-01 21:13:50 Re: SQL/JSON features for v15
Previous Message Nathan Bossart 2022-09-01 20:57:29 Re: allowing for control over SET ROLE