@@ -300,7 +300,7 @@ F661Simple tablesYES
300300F671Subqueries in CHECK constraintsNOintentionally omitted
301301F672Retrospective CHECK constraintsYES
302302F673Reads SQL-data routine invocations in CHECK constraintsNO
303- F690Collation supportYESbut no character set support
303+ F690Collation supportYES
304304F692Extended collation supportYES
305305F693SQL-session and client module collationsNO
306306F695Translation supportNO
@@ -425,7 +425,7 @@ T053Explicit aliases for all-fields referenceNO
425425T054GREATEST and LEASTYESdifferent null handling
426426T055String padding functionsYES
427427T056Multi-character TRIM functionsYES
428- T061UCS supportNO
428+ T061UCS supportYES
429429T062Character length unitsNO
430430T071BIGINT data typeYES
431431T076DECFLOAT data typeNO
@@ -543,21 +543,21 @@ T662Underscores in numeric literalsYES
543543T670Schema and data statement mixingYES
544544T801JSON data typeNO
545545T802Enhanced JSON data typeNO
546- T803String-based JSONNO
547- T811Basic SQL/JSON constructor functionsNO
548- T812SQL/JSON: JSON_OBJECTAGGNO
549- T813SQL/JSON: JSON_ARRAYAGG with ORDER BYNO
550- T814Colon in JSON_OBJECT or JSON_OBJECTAGGNO
546+ T803String-based JSONYES
547+ T811Basic SQL/JSON constructor functionsYES
548+ T812SQL/JSON: JSON_OBJECTAGGYES
549+ T813SQL/JSON: JSON_ARRAYAGG with ORDER BYYES
550+ T814Colon in JSON_OBJECT or JSON_OBJECTAGGYES
551551T821Basic SQL/JSON query operatorsNO
552- T822SQL/JSON: IS JSON WITH UNIQUE KEYS predicateNO
552+ T822SQL/JSON: IS JSON WITH UNIQUE KEYS predicateYES
553553T823SQL/JSON: PASSING clauseNO
554554T824JSON_TABLE: specific PLAN clauseNO
555555T825SQL/JSON: ON EMPTY and ON ERROR clausesNO
556556T826General value expression in ON ERROR or ON EMPTY clausesNO
557557T827JSON_TABLE: sibling NESTED COLUMNS clausesNO
558558T828JSON_QUERYNO
559559T829JSON_QUERY: array wrapper optionsNO
560- T830Enforcing unique keys in SQL/JSON constructor functionsNO
560+ T830Enforcing unique keys in SQL/JSON constructor functionsYES
561561T831SQL/JSON path language: strict modeYES
562562T832SQL/JSON path language: item methodYES
563563T833SQL/JSON path language: multiple subscriptsYES
@@ -568,7 +568,7 @@ T837SQL/JSON path language: regex_like predicateYES
568568T838JSON_TABLE: PLAN DEFAULT clauseNO
569569T839Formatted cast of datetimes to/from character stringsNO
570570T840Hex integer literals in SQL/JSON path languageYES
571- T851SQL/JSON: optional keywords for default syntaxNO
571+ T851SQL/JSON: optional keywords for default syntaxYES
572572T860SQL/JSON simplified accessor: column reference onlyNO
573573T861SQL/JSON simplified accessor: case-sensitive JSON member accessorNO
574574T862SQL/JSON simplified accessor: wildcard member accessorNO
@@ -588,9 +588,9 @@ T875SQL/JSON item method: time precisionNO
588588T876SQL/JSON item method: timestamp()NO
589589T877SQL/JSON item method: timestamp_tz()NO
590590T878SQL/JSON item method: timestamp precisionNO
591- T879JSON in equality operationsNO
592- T880JSON in grouping operationsNO
593- T881JSON in ordering operationsNO
591+ T879JSON in equality operationsYESwith jsonb
592+ T880JSON in grouping operationsYESwith jsonb
593+ T881JSON in ordering operationsNOwith jsonb, partially supported
594594T882JSON in multiset element grouping operationsNO
595595M001DatalinksNO
596596M002Datalinks via SQL/CLINO