|
B012
|
|
Embedded C
|
|
|
B021
|
|
Direct SQL
|
|
|
B128
|
|
Routine language SQL
|
|
|
E011
|
Core
|
Numeric data types
|
|
|
E011-01
|
Core
|
INTEGER and SMALLINT data types
|
|
|
E011-02
|
Core
|
REAL, DOUBLE PRECISION, and FLOAT data types
|
|
|
E011-03
|
Core
|
DECIMAL and NUMERIC data types
|
|
|
E011-04
|
Core
|
Arithmetic operators
|
|
|
E011-05
|
Core
|
Numeric comparison
|
|
|
E011-06
|
Core
|
Implicit casting among the numeric data types
|
|
|
E021
|
Core
|
Character data types
|
|
|
E021-01
|
Core
|
CHARACTER data type
|
|
|
E021-02
|
Core
|
CHARACTER VARYING data type
|
|
|
E021-03
|
Core
|
Character literals
|
|
|
E021-04
|
Core
|
CHARACTER_LENGTH function
|
trims trailing spaces from CHARACTER values before counting
|
|
E021-05
|
Core
|
OCTET_LENGTH function
|
|
|
E021-06
|
Core
|
SUBSTRING function
|
|
|
E021-07
|
Core
|
Character concatenation
|
|
|
E021-08
|
Core
|
UPPER and LOWER functions
|
|
|
E021-09
|
Core
|
TRIM function
|
|
|
E021-10
|
Core
|
Implicit casting among the character string types
|
|
|
E021-11
|
Core
|
POSITION function
|
|
|
E021-12
|
Core
|
Character comparison
|
|
|
E031
|
Core
|
Identifiers
|
|
|
E031-01
|
Core
|
Delimited identifiers
|
|
|
E031-02
|
Core
|
Lower case identifiers
|
|
|
E031-03
|
Core
|
Trailing underscore
|
|
|
E051
|
Core
|
Basic query specification
|
|
|
E051-01
|
Core
|
SELECT DISTINCT
|
|
|
E051-02
|
Core
|
GROUP BY clause
|
|
|
E051-04
|
Core
|
GROUP BY can contain columns not in |
|
|
E051-05
|
Core
|
Select list items can be renamed
|
|
|
E051-06
|
Core
|
HAVING clause
|
|
|
E051-07
|
Core
|
Qualified * in select list
|
|
|
E051-08
|
Core
|
Correlation names in the FROM clause
|
|
|
E051-09
|
Core
|
Rename columns in the FROM clause
|
|
|
E061
|
Core
|
Basic predicates and search conditions
|
|
|
E061-01
|
Core
|
Comparison predicate
|
|
|
E061-02
|
Core
|
BETWEEN predicate
|
|
|
E061-03
|
Core
|
IN predicate with list of values
|
|
|
E061-04
|
Core
|
LIKE predicate
|
|
|
E061-05
|
Core
|
LIKE predicate ESCAPE clause
|
|
|
E061-06
|
Core
|
NULL predicate
|
|
|
E061-07
|
Core
|
Quantified comparison predicate
|
|
|
E061-08
|
Core
|
EXISTS predicate
|
|
|
E061-09
|
Core
|
Subqueries in comparison predicate
|
|
|
E061-11
|
Core
|
Subqueries in IN predicate
|
|
|
E061-12
|
Core
|
Subqueries in quantified comparison predicate
|
|
|
E061-13
|
Core
|
Correlated subqueries
|
|
|
E061-14
|
Core
|
Search condition
|
|
|
E071
|
Core
|
Basic query expressions
|
|
|
E071-01
|
Core
|
UNION DISTINCT table operator
|
|
|
E071-02
|
Core
|
UNION ALL table operator
|
|
|
E071-03
|
Core
|
EXCEPT DISTINCT table operator
|
|
|
E071-05
|
Core
|
Columns combined via table operators need not have exactly the same data type
|
|
|
E071-06
|
Core
|
Table operators in subqueries
|
|
|
E081
|
Core
|
Basic Privileges
|
|
|
E081-01
|
Core
|
SELECT privilege
|
|
|
E081-02
|
Core
|
DELETE privilege
|
|
|
E081-03
|
Core
|
INSERT privilege at the table level
|
|
|
E081-04
|
Core
|
UPDATE privilege at the table level
|
|
|
E081-05
|
Core
|
UPDATE privilege at the column level
|
|
|
E081-06
|
Core
|
REFERENCES privilege at the table level
|
|
|
E081-07
|
Core
|
REFERENCES privilege at the column level
|
|
|
E081-08
|
Core
|
WITH GRANT OPTION
|
|
|
E081-09
|
Core
|
USAGE privilege
|
|
|
E081-10
|
Core
|
EXECUTE privilege
|
|
|
E091
|
Core
|
Set functions
|
|
|
E091-01
|
Core
|
AVG
|
|
|
E091-02
|
Core
|
COUNT
|
|
|
E091-03
|
Core
|
MAX
|
|
|
E091-04
|
Core
|
MIN
|
|
|
E091-05
|
Core
|
SUM
|
|
|
E091-06
|
Core
|
ALL quantifier
|
|
|
E091-07
|
Core
|
DISTINCT quantifier
|
|
|
E101
|
Core
|
Basic data manipulation
|
|
|
E101-01
|
Core
|
INSERT statement
|
|
|
E101-03
|
Core
|
Searched UPDATE statement
|
|
|
E101-04
|
Core
|
Searched DELETE statement
|
|
|
E111
|
Core
|
Single row SELECT statement
|
|
|
E121
|
Core
|
Basic cursor support
|
|
|
E121-01
|
Core
|
DECLARE CURSOR
|
|
|
E121-02
|
Core
|
ORDER BY columns need not be in select list
|
|
|
E121-03
|
Core
|
Value expressions in ORDER BY clause
|
|
|
E121-04
|
Core
|
OPEN statement
|
|
|
E121-06
|
Core
|
Positioned UPDATE statement
|
|
|
E121-07
|
Core
|
Positioned DELETE statement
|
|
|
E121-08
|
Core
|
CLOSE statement
|
|
|
E121-10
|
Core
|
FETCH statement implicit NEXT
|
|
|
E121-17
|
Core
|
WITH HOLD cursors
|
|
|
E131
|
Core
|
Null value support (nulls in lieu of values)
|
|
|
E141
|
Core
|
Basic integrity constraints
|
|
|
E141-01
|
Core
|
NOT NULL constraints
|
|
|
E141-02
|
Core
|
UNIQUE constraints of NOT NULL columns
|
|
|
E141-03
|
Core
|
PRIMARY KEY constraints
|
|
|
E141-04
|
Core
|
Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action
|
|
|
E141-06
|
Core
|
CHECK constraints
|
|
|
E141-07
|
Core
|
Column defaults
|
|
|
E141-08
|
Core
|
NOT NULL inferred on PRIMARY KEY
|
|
|
E141-10
|
Core
|
Names in a foreign key can be specified in any order
|
|
|
E151
|
Core
|
Transaction support
|
|
|
E151-01
|
Core
|
COMMIT statement
|
|
|
E151-02
|
Core
|
ROLLBACK statement
|
|
|
E152
|
Core
|
Basic SET TRANSACTION statement
|
|
|
E152-01
|
Core
|
SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause
|
|
|
E152-02
|
Core
|
SET TRANSACTION statement: READ ONLY and READ WRITE clauses
|
|
|
E153
|
Core
|
Updatable queries with subqueries
|
|
|
E161
|
Core
|
SQL comments using leading double minus
|
|
|
E171
|
Core
|
SQLSTATE support
|
|
|
E182
|
Core
|
Host language binding
|
|
|
F021
|
Core
|
Basic information schema
|
|
|
F021-01
|
Core
|
COLUMNS view
|
|
|
F021-02
|
Core
|
TABLES view
|
|
|
F021-03
|
Core
|
VIEWS view
|
|
|
F021-04
|
Core
|
TABLE_CONSTRAINTS view
|
|
|
F021-05
|
Core
|
REFERENTIAL_CONSTRAINTS view
|
|
|
F021-06
|
Core
|
CHECK_CONSTRAINTS view
|
|
|
F031
|
Core
|
Basic schema manipulation
|
|
|
F031-01
|
Core
|
CREATE TABLE statement to create persistent base tables
|
|
|
F031-02
|
Core
|
CREATE VIEW statement
|
|
|
F031-03
|
Core
|
GRANT statement
|
|
|
F031-04
|
Core
|
ALTER TABLE statement: ADD COLUMN clause
|
|
|
F031-13
|
Core
|
DROP TABLE statement: RESTRICT clause
|
|
|
F031-16
|
Core
|
DROP VIEW statement: RESTRICT clause
|
|
|
F031-19
|
Core
|
REVOKE statement: RESTRICT clause
|
|
|
F032
|
|
CASCADE drop behavior
|
|
|
F033
|
|
ALTER TABLE statement: DROP COLUMN clause
|
|
|
F034
|
|
Extended REVOKE statement
|
|
|
F035
|
|
REVOKE with CASCADE
|
|
|
F036
|
|
REVOKE statement performed by non-owner
|
|
|
F037
|
|
REVOKE statement: GRANT OPTION FOR clause
|
|
|
F038
|
|
REVOKE of a WITH GRANT OPTION privilege
|
|
|
F041
|
Core
|
Basic joined table
|
|
|
F041-01
|
Core
|
Inner join (but not necessarily the INNER keyword)
|
|
|
F041-02
|
Core
|
INNER keyword
|
|
|
F041-03
|
Core
|
LEFT OUTER JOIN
|
|
|
F041-04
|
Core
|
RIGHT OUTER JOIN
|
|
|
F041-05
|
Core
|
Outer joins can be nested
|
|
|
F041-07
|
Core
|
The inner table in a left or right outer join can also be used in an inner join
|
|
|
F041-08
|
Core
|
All comparison operators are supported (rather than just =)
|
|
|
F051
|
Core
|
Basic date and time
|
|
|
F051-01
|
Core
|
DATE data type (including support of DATE literal)
|
|
|
F051-02
|
Core
|
TIME data type (including support of TIME literal) with fractional seconds precision of at least 0
|
|
|
F051-03
|
Core
|
TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6
|
|
|
F051-04
|
Core
|
Comparison predicate on DATE, TIME, and TIMESTAMP data types
|
|
|
F051-05
|
Core
|
Explicit CAST between datetime types and character string types
|
|
|
F051-06
|
Core
|
CURRENT_DATE
|
|
|
F051-07
|
Core
|
LOCALTIME
|
|
|
F051-08
|
Core
|
LOCALTIMESTAMP
|
|
|
F052
|
|
Intervals and datetime arithmetic
|
|
|
F053
|
|
OVERLAPS predicate
|
|
|
F081
|
Core
|
UNION and EXCEPT in views
|
|
|
F111
|
|
Isolation levels other than SERIALIZABLE
|
|
|
F112
|
|
Isolation level READ UNCOMMITTED
|
|
|
F113
|
|
Isolation level READ COMMITTED
|
|
|
F114
|
|
Isolation level REPEATABLE READ
|
|
|
F131
|
Core
|
Grouped operations
|
|
|
F131-01
|
Core
|
WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views
|
|
|
F131-02
|
Core
|
Multiple tables supported in queries with grouped views
|
|
|
F131-03
|
Core
|
Set functions supported in queries with grouped views
|
|
|
F131-04
|
Core
|
Subqueries with GROUP BY and HAVING clauses and grouped views
|
|
|
F131-05
|
Core
|
Single row SELECT with GROUP BY and HAVING clauses and grouped views
|
|
|
F171
|
|
Multiple schemas per user
|
|
|
F181
|
Core
|
Multiple module support
|
|
|
F191
|
|
Referential delete actions
|
|
|
F200
|
|
TRUNCATE TABLE statement
|
|
|
F201
|
Core
|
CAST function
|
|
|
F202
|
|
TRUNCATE TABLE: identity column restart option
|
|
|
F221
|
Core
|
Explicit defaults
|
|
|
F222
|
|
INSERT statement: DEFAULT VALUES clause
|
|
|
F231
|
|
Privilege tables
|
|
|
F251
|
|
Domain support
|
|
|
F261
|
Core
|
CASE expression
|
|
|
F261-01
|
Core
|
Simple CASE
|
|
|
F261-02
|
Core
|
Searched CASE
|
|
|
F261-03
|
Core
|
NULLIF
|
|
|
F261-04
|
Core
|
COALESCE
|
|
|
F262
|
|
Extended CASE expression
|
|
|
F271
|
|
Compound character literals
|
|
|
F281
|
|
LIKE enhancements
|
|
|
F292
|
|
UNIQUE null treatment
|
|
|
F302
|
|
INTERSECT table operator
|
|
|
F303
|
|
INTERSECT DISTINCT table operator
|
|
|
F304
|
|
EXCEPT ALL table operator
|
|
|
F305
|
|
INTERSECT ALL table operator
|
|
|
F311
|
Core
|
Schema definition statement
|
|
|
F311-01
|
Core
|
CREATE SCHEMA
|
|
|
F311-02
|
Core
|
CREATE TABLE for persistent base tables
|
|
|
F311-03
|
Core
|
CREATE VIEW
|
|
|
F311-04
|
Core
|
CREATE VIEW: WITH CHECK OPTION
|
|
|
F311-05
|
Core
|
GRANT statement
|
|
|
F312
|
|
MERGE statement
|
|
|
F313
|
|
Enhanced MERGE statement
|
|
|
F314
|
|
MERGE statement with DELETE branch
|
|
|
F321
|
|
User authorization
|
|
|
F341
|
|
Usage tables
|
|
|
F361
|
|
Subprogram support
|
|
|
F381
|
|
Extended schema manipulation
|
|
|
F382
|
|
Alter column data type
|
|
|
F383
|
|
Set column not null clause
|
|
|
F384
|
|
Drop identity property clause
|
|
|
F385
|
|
Drop column generation expression clause
|
|
|
F386
|
|
Set identity column generation clause
|
|
|
F387
|
|
ALTER TABLE statement: ALTER COLUMN clause
|
|
|
F388
|
|
ALTER TABLE statement: ADD/DROP CONSTRAINT clause
|
|
|
F391
|
|
Long identifiers
|
|
|
F392
|
|
Unicode escapes in identifiers
|
|
|
F393
|
|
Unicode escapes in literals
|
|
|
F394
|
|
Optional normal form specification
|
|
|
F401
|
|
Extended joined table
|
|
|
F402
|
|
Named column joins for LOBs, arrays, and multisets
|
|
|
F404
|
|
Range variable for common column names
|
|
|
F405
|
|
NATURAL JOIN
|
|
|
F406
|
|
FULL OUTER JOIN
|
|
|
F407
|
|
CROSS JOIN
|
|
|
F411
|
|
Time zone specification
|
differences regarding literal interpretation
|
|
F421
|
|
National character
|
|
|
F431
|
|
Read-only scrollable cursors
|
|
|
F432
|
|
FETCH with explicit NEXT
|
|
|
F433
|
|
FETCH FIRST
|
|
|
F434
|
|
FETCH LAST
|
|
|
F435
|
|
FETCH PRIOR
|
|
|
F436
|
|
FETCH ABSOLUTE
|
|
|
F437
|
|
FETCH RELATIVE
|
|
|
F438
|
|
Scrollable cursors
|
|
|
F441
|
|
Extended set function support
|
|
|
F442
|
|
Mixed column references in set functions
|
|
|
F471
|
Core
|
Scalar subquery values
|
|
|
F481
|
Core
|
Expanded NULL predicate
|
|
|
F491
|
|
Constraint management
|
|
|
F501
|
Core
|
Features and conformance views
|
|
|
F501-01
|
Core
|
SQL_FEATURES view
|
|
|
F501-02
|
Core
|
SQL_SIZING view
|
|
|
F502
|
|
Enhanced documentation tables
|
|
|
F531
|
|
Temporary tables
|
|
|
F555
|
|
Enhanced seconds precision
|
|
|
F561
|
|
Full value expressions
|
|
|
F571
|
|
Truth value tests
|
|
|
F591
|
|
Derived tables
|
|
|
F611
|
|
Indicator data types
|
|
|
F641
|
|
Row and table constructors
|
|
|
F651
|
|
Catalog name qualifiers
|
|
|
F661
|
|
Simple tables
|
|
|
F672
|
|
Retrospective CHECK constraints
|
|
|
F690
|
|
Collation support
|
|
|
F692
|
|
Extended collation support
|
|
|
F701
|
|
Referential update actions
|
|
|
F711
|
|
ALTER domain
|
|
|
F731
|
|
INSERT column privileges
|
|
|
F751
|
|
View CHECK enhancements
|
|
|
F761
|
|
Session management
|
|
|
F762
|
|
CURRENT_CATALOG
|
|
|
F763
|
|
CURRENT_SCHEMA
|
|
|
F771
|
|
Connection management
|
|
|
F781
|
|
Self-referencing operations
|
|
|
F791
|
|
Insensitive cursors
|
|
|
F801
|
|
Full set function
|
|
|
F850
|
|
Top-level ORDER BY in query expression
|
|
|
F851
|
|
ORDER BY in subqueries
|
|
|
F852
|
|
Top-level ORDER BY in views
|
|
|
F855
|
|
Nested ORDER BY in query expression
|
|
|
F856
|
|
Nested FETCH FIRST in query expression
|
|
|
F857
|
|
Top-level FETCH FIRST in query expression
|
|
|
F858
|
|
FETCH FIRST in subqueries
|
|
|
F859
|
|
Top-level FETCH FIRST in views
|
|
|
F860
|
|
Dynamic FETCH FIRST row count
|
|
|
F861
|
|
Top-level OFFSET in query expression
|
|
|
F862
|
|
OFFSET in subqueries
|
|
|
F863
|
|
Nested OFFSET in query expression
|
|
|
F864
|
|
Top-level OFFSET in views
|
|
|
F865
|
|
Dynamic offset row count in OFFSET
|
|
|
F867
|
|
FETCH FIRST clause: WITH TIES option
|
|
|
F868
|
|
ORDER BY in grouped table
|
|
|
F869
|
|
SQL implementation info population
|
|
|
S071
|
|
SQL paths in function and type name resolution
|
|
|
S090
|
|
Minimal array support
|
|
|
S092
|
|
Arrays of user-defined types
|
|
|
S095
|
|
Array constructors by query
|
|
|
S096
|
|
Optional array bounds
|
|
|
S098
|
|
ARRAY_AGG
|
|
|
S099
|
|
Array expressions
|
|
|
S111
|
|
ONLY in query expressions
|
|
|
S201
|
|
SQL-invoked routines on arrays
|
|
|
S203
|
|
Array parameters
|
|
|
S204
|
|
Array as result type of functions
|
|
|
S211
|
|
User-defined cast functions
|
|
|
S301
|
|
Enhanced UNNEST
|
|
|
S404
|
|
TRIM_ARRAY
|
|
|
T031
|
|
BOOLEAN data type
|
|
|
T054
|
|
GREATEST and LEAST
|
different null handling
|
|
T055
|
|
String padding functions
|
|
|
T056
|
|
Multi-character TRIM functions
|
|
|
T061
|
|
UCS support
|
|
|
T071
|
|
BIGINT data type
|
|
|
T081
|
|
Optional string types maximum length
|
|
|
T121
|
|
WITH (excluding RECURSIVE) in query expression
|
|
|
T122
|
|
WITH (excluding RECURSIVE) in subquery
|
|
|
T131
|
|
Recursive query
|
|
|
T132
|
|
Recursive query in subquery
|
|
|
T133
|
|
Enhanced cycle mark values
|
|
|
T141
|
|
SIMILAR predicate
|
|
|
T151
|
|
DISTINCT predicate
|
|
|
T152
|
|
DISTINCT predicate with negation
|
|
|
T171
|
|
LIKE clause in table definition
|
|
|
T172
|
|
AS subquery clause in table definition
|
|
|
T173
|
|
Extended LIKE clause in table definition
|
|
|
T174
|
|
Identity columns
|
|
|
T177
|
|
Sequence generator support: simple restart option
|
|
|
T178
|
|
Identity columns: simple restart option
|
|
|
T191
|
|
Referential action RESTRICT
|
|
|
T201
|
|
Comparable data types for referential constraints
|
|
|
T212
|
|
Enhanced trigger capability
|
|
|
T213
|
|
INSTEAD OF triggers
|
|
|
T214
|
|
BEFORE triggers
|
|
|
T215
|
|
AFTER triggers
|
|
|
T216
|
|
Ability to require true search condition before trigger is invoked
|
|
|
T217
|
|
TRIGGER privilege
|
|
|
T241
|
|
START TRANSACTION statement
|
|
|
T261
|
|
Chained transactions
|
|
|
T271
|
|
Savepoints
|
|
|
T281
|
|
SELECT privilege with column granularity
|
|
|
T285
|
|
Enhanced derived column names
|
|
|
T312
|
|
OVERLAY function
|
|
|
T321-01
|
Core
|
User-defined functions with no overloading
|
|
|
T321-02
|
Core
|
User-defined stored procedures with no overloading
|
|
|
T321-03
|
Core
|
Function invocation
|
|
|
T321-04
|
Core
|
CALL statement
|
|
|
T321-05
|
Core
|
RETURN statement
|
|
|
T321-06
|
Core
|
ROUTINES view
|
|
|
T321-07
|
Core
|
PARAMETERS view
|
|
|
T323
|
|
Explicit security for external routines
|
|
|
T325
|
|
Qualified SQL parameter references
|
|
|
T331
|
|
Basic roles
|
|
|
T332
|
|
Extended roles
|
|
|
T341
|
|
Overloading of SQL-invoked functions and SQL-invoked procedures
|
|
|
T351
|
|
Bracketed comments
|
|
|
T431
|
|
Extended grouping capabilities
|
|
|
T432
|
|
Nested and concatenated GROUPING SETS
|
|
|
T433
|
|
Multi-argument GROUPING function
|
|
|
T434
|
|
GROUP BY DISTINCT
|
|
|
T441
|
|
ABS and MOD functions
|
|
|
T461
|
|
Symmetric BETWEEN predicate
|
|
|
T491
|
|
LATERAL derived table
|
|
|
T501
|
|
Enhanced EXISTS predicate
|
|
|
T521
|
|
Named arguments in CALL statement
|
|
|
T523
|
|
Default values for INOUT parameters of SQL-invoked procedures
|
|
|
T524
|
|
Named arguments in routine invocations other than a CALL statement
|
|
|
T525
|
|
Default values for parameters of SQL-invoked functions
|
|
|
T551
|
|
Optional key words for default syntax
|
|
|
T581
|
|
Regular expression substring function
|
|
|
T591
|
|
UNIQUE constraints of possibly null columns
|
|
|
T611
|
|
Elementary OLAP operations
|
|
|
T612
|
|
Advanced OLAP operations
|
|
|
T613
|
|
Sampling
|
|
|
T614
|
|
NTILE function
|
|
|
T615
|
|
LEAD and LAG functions
|
|
|
T617
|
|
FIRST_VALUE and LAST_VALUE functions
|
|
|
T620
|
|
WINDOW clause: GROUPS option
|
|
|
T621
|
|
Enhanced numeric functions
|
|
|
T622
|
|
Trigonometric functions
|
|
|
T623
|
|
General logarithm functions
|
|
|
T624
|
|
Common logarithm functions
|
|
|
T626
|
|
ANY_VALUE
|
|
|
T627
|
|
Window framed COUNT DISTINCT
|
|
|
T631
|
Core
|
IN predicate with one list element
|
|
|
T651
|
|
SQL-schema statements in SQL routines
|
|
|
T653
|
|
SQL-schema statements in external routines
|
|
|
T655
|
|
Cyclically dependent routines
|
|
|
T661
|
|
Non-decimal integer literals
|
|
|
T662
|
|
Underscores in numeric literals
|
|
|
T670
|
|
Schema and data statement mixing
|
|
|
T803
|
|
String-based JSON
|
|
|
T811
|
|
Basic SQL/JSON constructor functions
|
|
|
T812
|
|
SQL/JSON: JSON_OBJECTAGG
|
|
|
T813
|
|
SQL/JSON: JSON_ARRAYAGG with ORDER BY
|
|
|
T814
|
|
Colon in JSON_OBJECT or JSON_OBJECTAGG
|
|
|
T821
|
|
Basic SQL/JSON query operators
|
|
|
T822
|
|
SQL/JSON: IS JSON WITH UNIQUE KEYS predicate
|
|
|
T823
|
|
SQL/JSON: PASSING clause
|
|
|
T825
|
|
SQL/JSON: ON EMPTY and ON ERROR clauses
|
|
|
T826
|
|
General value expression in ON ERROR or ON EMPTY clauses
|
|
|
T827
|
|
JSON_TABLE: sibling NESTED COLUMNS clauses
|
|
|
T828
|
|
JSON_QUERY
|
|
|
T829
|
|
JSON_QUERY: array wrapper options
|
|
|
T830
|
|
Enforcing unique keys in SQL/JSON constructor functions
|
|
|
T831
|
|
SQL/JSON path language: strict mode
|
|
|
T832
|
|
SQL/JSON path language: item method
|
|
|
T833
|
|
SQL/JSON path language: multiple subscripts
|
|
|
T834
|
|
SQL/JSON path language: wildcard member accessor
|
|
|
T835
|
|
SQL/JSON path language: filter expressions
|
|
|
T836
|
|
SQL/JSON path language: starts with predicate
|
|
|
T837
|
|
SQL/JSON path language: regex_like predicate
|
|
|
T840
|
|
Hex integer literals in SQL/JSON path language
|
|
|
T851
|
|
SQL/JSON: optional keywords for default syntax
|
|
|
T865
|
|
SQL/JSON item method: bigint()
|
|
|
T866
|
|
SQL/JSON item method: boolean()
|
|
|
T867
|
|
SQL/JSON item method: date()
|
|
|
T868
|
|
SQL/JSON item method: decimal()
|
|
|
T869
|
|
SQL/JSON item method: decimal() with precision and scale
|
|
|
T870
|
|
SQL/JSON item method: integer()
|
|
|
T871
|
|
SQL/JSON item method: number()
|
|
|
T872
|
|
SQL/JSON item method: string()
|
|
|
T873
|
|
SQL/JSON item method: time()
|
|
|
T874
|
|
SQL/JSON item method: time_tz()
|
|
|
T875
|
|
SQL/JSON item method: time precision
|
|
|
T876
|
|
SQL/JSON item method: timestamp()
|
|
|
T877
|
|
SQL/JSON item method: timestamp_tz()
|
|
|
T878
|
|
SQL/JSON item method: timestamp precision
|
|
|
T879
|
|
JSON in equality operations
|
with jsonb
|
|
T880
|
|
JSON in grouping operations
|
with jsonb
|
|
X010
|
|
XML type
|
|
|
X011
|
|
Arrays of XML type
|
|
|
X014
|
|
Attributes of XML type
|
|
|
X016
|
|
Persistent XML values
|
|
|
X020
|
|
XMLConcat
|
|
|
X031
|
|
XMLElement
|
|
|
X032
|
|
XMLForest
|
|
|
X034
|
|
XMLAgg
|
|
|
X035
|
|
XMLAgg: ORDER BY option
|
|
|
X036
|
|
XMLComment
|
|
|
X037
|
|
XMLPI
|
|
|
X038
|
|
XMLText
|
supported except for RETURNING
|
|
X040
|
|
Basic table mapping
|
|
|
X041
|
|
Basic table mapping: null absent
|
|
|
X042
|
|
Basic table mapping: null as nil
|
|
|
X043
|
|
Basic table mapping: table as forest
|
|
|
X044
|
|
Basic table mapping: table as element
|
|
|
X045
|
|
Basic table mapping: with target namespace
|
|
|
X046
|
|
Basic table mapping: data mapping
|
|
|
X047
|
|
Basic table mapping: metadata mapping
|
|
|
X048
|
|
Basic table mapping: base64 encoding of binary strings
|
|
|
X049
|
|
Basic table mapping: hex encoding of binary strings
|
|
|
X050
|
|
Advanced table mapping
|
|
|
X051
|
|
Advanced table mapping: null absent
|
|
|
X052
|
|
Advanced table mapping: null as nil
|
|
|
X053
|
|
Advanced table mapping: table as forest
|
|
|
X054
|
|
Advanced table mapping: table as element
|
|
|
X055
|
|
Advanced table mapping: with target namespace
|
|
|
X056
|
|
Advanced table mapping: data mapping
|
|
|
X057
|
|
Advanced table mapping: metadata mapping
|
|
|
X058
|
|
Advanced table mapping: base64 encoding of binary strings
|
|
|
X059
|
|
Advanced table mapping: hex encoding of binary strings
|
|
|
X060
|
|
XMLParse: character string input and CONTENT option
|
|
|
X061
|
|
XMLParse: character string input and DOCUMENT option
|
|
|
X069
|
|
XMLSerialize: INDENT
|
|
|
X070
|
|
XMLSerialize: character string serialization and CONTENT option
|
|
|
X071
|
|
XMLSerialize: character string serialization and DOCUMENT option
|
|
|
X072
|
|
XMLSerialize: character string serialization
|
|
|
X090
|
|
XML document predicate
|
|
|
X120
|
|
XML parameters in SQL routines
|
|
|
X121
|
|
XML parameters in external routines
|
|
|
X221
|
|
XML passing mechanism BY VALUE
|
|
|
X301
|
|
XMLTable: derived column list option
|
|
|
X302
|
|
XMLTable: ordinality column option
|
|
|
X303
|
|
XMLTable: column default option
|
|
|
X304
|
|
XMLTable: passing a context item
|
must be XML DOCUMENT
|
|
X400
|
|
Name and identifier mapping
|
|
|
X410
|
|
Alter column data type: XML type
|
|