pgsql: Revert SQL/JSON features - Mailing list pgsql-committers

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
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/2f2b18bd3f554e96a8cc885b177211be12288e4a

Modified Files
--------------
doc/src/sgml/func.sgml                        | 1065 +-----------
doc/src/sgml/keywords/sql2016-02-reserved.txt |    1 -
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/makefuncs.c                 |  122 --
src/backend/nodes/nodeFuncs.c                 |  486 ------
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               | 1503 -----------------
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/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      |   28 -
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 -
60 files changed, 348 insertions(+), 14893 deletions(-)