Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit2f2b18b

Browse files
committed
Revert SQL/JSON features
The reverts the following and makes some associated cleanups: commitf79b803: Common SQL/JSON clauses commitf4fb45d: SQL/JSON constructors commit5f0adec: Make STRING an unreserved_keyword. commit33a3776: IS JSON predicate commit1a36bc9: SQL/JSON query functions commit606948b: SQL JSON functions commit49082c2: RETURNING clause for JSON() and JSON_SCALAR() commit4e34747: JSON_TABLE commitfadb48b: PLAN clauses for JSON_TABLE commit2ef6f11: Reduce running time of jsonb_sqljson test commit14d3f24: Further improve jsonb_sqljson parallel test commita6baa4b: Documentation for SQL/JSON features commitb46bcf7: Improve readability of SQL/JSON documentation. commit112fdb3: Fix finalization for json_objectagg and friends commitfcdb35c: Fix transformJsonBehavior commit4cd8717: Improve a couple of sql/json error messages commitf7a605f: Small cleanups in SQL/JSON code commit9c3d25e: Fix JSON_OBJECTAGG uniquefying bug commita79153b: Claim SQL standard compliance for SQL/JSON features commita1e7616: Rework SQL/JSON documentation commit8d9f963: Fix errors in copyfuncs/equalfuncs support for JSON node types. commit3c633f3: Only allow returning string types or bytea from json_serialize commit67b2670: 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
1 parent90247e7 commit2f2b18b

File tree

60 files changed

+348
-14893
lines changed

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

60 files changed

+348
-14893
lines changed

‎doc/src/sgml/func.sgml

Lines changed: 6 additions & 1059 deletions
Large diffs are not rendered by default.

‎doc/src/sgml/keywords/sql2016-02-reserved.txt

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -157,7 +157,6 @@ INTERVAL
157157
INTO
158158
IS
159159
JOIN
160-
JSON
161160
JSON_ARRAY
162161
JSON_ARRAYAGG
163162
JSON_EXISTS

‎src/backend/catalog/sql_features.txt

Lines changed: 15 additions & 15 deletions
Original file line numberDiff line numberDiff line change
@@ -527,28 +527,28 @@ T652SQL-dynamic statements in SQL routinesNO
527527
T653SQL-schema statements in external routinesYES
528528
T654SQL-dynamic statements in external routinesNO
529529
T655Cyclically dependent routinesYES
530-
T811Basic SQL/JSON constructor functionsYES
531-
T812SQL/JSON: JSON_OBJECTAGGYES
532-
T813SQL/JSON: JSON_ARRAYAGG with ORDER BYYES
533-
T814Colon in JSON_OBJECT or JSON_OBJECTAGGYES
534-
T821Basic SQL/JSON query operatorsYES
535-
T822SQL/JSON: IS JSON WITH UNIQUE KEYS predicateYES
536-
T823SQL/JSON: PASSING clauseYES
537-
T824JSON_TABLE: specific PLAN clauseYES
538-
T825SQL/JSON: ON EMPTY and ON ERROR clausesYES
539-
T826General value expression in ON ERROR or ON EMPTY clausesYES
540-
T827JSON_TABLE: sibling NESTED COLUMNS clausesYES
541-
T828JSON_QUERYYES
542-
T829JSON_QUERY: array wrapper optionsYES
543-
T830Enforcing unique keys in SQL/JSON constructor functionsYES
530+
T811Basic SQL/JSON constructor functionsNO
531+
T812SQL/JSON: JSON_OBJECTAGGNO
532+
T813SQL/JSON: JSON_ARRAYAGG with ORDER BYNO
533+
T814Colon in JSON_OBJECT or JSON_OBJECTAGGNO
534+
T821Basic SQL/JSON query operatorsNO
535+
T822SQL/JSON: IS JSON WITH UNIQUE KEYS predicateNO
536+
T823SQL/JSON: PASSING clauseNO
537+
T824JSON_TABLE: specific PLAN clauseNO
538+
T825SQL/JSON: ON EMPTY and ON ERROR clausesNO
539+
T826General value expression in ON ERROR or ON EMPTY clausesNO
540+
T827JSON_TABLE: sibling NESTED COLUMNS clausesNO
541+
T828JSON_QUERYNO
542+
T829JSON_QUERY: array wrapper optionsNO
543+
T830Enforcing unique keys in SQL/JSON constructor functionsNO
544544
T831SQL/JSON path language: strict modeYES
545545
T832SQL/JSON path language: item methodYES
546546
T833SQL/JSON path language: multiple subscriptsYES
547547
T834SQL/JSON path language: wildcard member accessorYES
548548
T835SQL/JSON path language: filter expressionsYES
549549
T836SQL/JSON path language: starts with predicateYES
550550
T837SQL/JSON path language: regex_like predicateYES
551-
T838JSON_TABLE: PLAN DEFAULT clauseYES
551+
T838JSON_TABLE: PLAN DEFAULT clauseNO
552552
T839Formatted cast of datetimes to/from character stringsNO
553553
M001DatalinksNO
554554
M002Datalinks via SQL/CLINO

‎src/backend/commands/explain.c

Lines changed: 1 addition & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -3851,13 +3851,7 @@ ExplainTargetRel(Plan *plan, Index rti, ExplainState *es)
38513851
break;
38523852
caseT_TableFuncScan:
38533853
Assert(rte->rtekind==RTE_TABLEFUNC);
3854-
if (rte->tablefunc)
3855-
if (rte->tablefunc->functype==TFT_XMLTABLE)
3856-
objectname="xmltable";
3857-
else/* Must be TFT_JSON_TABLE */
3858-
objectname="json_table";
3859-
else
3860-
objectname=NULL;
3854+
objectname="xmltable";
38613855
objecttag="Table Function Name";
38623856
break;
38633857
caseT_ValuesScan:

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp