@@ -29,6 +29,16 @@ B125Routine language MUMPSNO
29
29
B126Routine language PascalNO
30
30
B127Routine language PL/INO
31
31
B128Routine language SQLNO
32
+ B200Polymorphic table functionsNO
33
+ B201More than one PTF generic table parameterNO
34
+ B202PTF CopartitioningNO
35
+ B203More than one copartition specificationNO
36
+ B204PRUNE WHEN EMPTYNO
37
+ B205Pass-through columnsNO
38
+ B206PTF descriptor parametersNO
39
+ B207Cross products of partitioningsNO
40
+ B208PTF component procedure interfaceNO
41
+ B209PTF extended namesNO
32
42
B211Module language Ada: VARCHAR and NUMERIC supportNO
33
43
B221Routine language Ada: VARCHAR and NUMERIC supportNO
34
44
E011Numeric data typesYES
@@ -254,6 +264,7 @@ F401Extended joined table02FULL OUTER JOINYES
254
264
F401Extended joined table04CROSS JOINYES
255
265
F402Named column joins for LOBs, arrays, and multisetsYES
256
266
F403Partitioned joined tablesNO
267
+ F404Range variable for common column namesNO
257
268
F411Time zone specificationYESdifferences regarding literal interpretation
258
269
F421National characterYES
259
270
F431Read-only scrollable cursorsYES
@@ -291,6 +302,7 @@ F651Catalog name qualifiersYES
291
302
F661Simple tablesYES
292
303
F671Subqueries in CHECKNOintentionally omitted
293
304
F672Retrospective check constraintsYES
305
+ F673Reads SQL-data routine invocations in CHECK constraintsNO
294
306
F690Collation supportYESbut no character set support
295
307
F692Extended collation supportYES
296
308
F693SQL-session and client module collationsNO
@@ -338,6 +350,9 @@ F864Top-level <result offset clause> in viewsYES
338
350
F865<offset row count> in <result offset clause>YES
339
351
F866FETCH FIRST clause: PERCENT optionNO
340
352
F867FETCH FIRST clause: WITH TIES optionNO
353
+ R010Row pattern recognition: FROM clauseNO
354
+ R020Row pattern recognition: WINDOW clauseNO
355
+ R030Row pattern recognition: full aggregate supportNO
341
356
S011Distinct data typesNO
342
357
S011Distinct data types01USER_DEFINED_TYPES viewNO
343
358
S023Basic structured typesNO
@@ -404,10 +419,10 @@ T042Extended LOB data type supportNO
404
419
T043Multiplier TNO
405
420
T044Multiplier PNO
406
421
T051Row typesNO
407
- T052MAX and MIN for row typesNO
408
422
T053Explicit aliases for all-fields referenceNO
409
423
T061UCS supportNO
410
424
T071BIGINT data typeYES
425
+ T076DECFLOAT data typeNO
411
426
T101Enhanced nullability determinationNO
412
427
T111Updatable joins, unions, and columnsNO
413
428
T121WITH (excluding RECURSIVE) in query expressionYES
@@ -482,6 +497,9 @@ T502Period predicatesNO
482
497
T511Transaction countsNO
483
498
T521Named arguments in CALL statementYES
484
499
T522Default values for IN parameters of SQL-invoked proceduresNOsupported except DEFAULT key word in invocation
500
+ T523Default values for INOUT parameters of SQL-invoked proceduresYES
501
+ T524Named arguments in routine invocations other than a CALL statementYES
502
+ T525Default values for parameters of SQL-invoked functionsYES
485
503
T551Optional key words for default syntaxYES
486
504
T561Holdable locatorsNO
487
505
T571Array-returning external SQL-invoked functionsNO
@@ -500,13 +518,40 @@ T618NTH_VALUE functionNOfunction exists, but some options missing
500
518
T619Nested window functionsNO
501
519
T620WINDOW clause: GROUPS optionYES
502
520
T621Enhanced numeric functionsYES
521
+ T622Trigonometric functionsYES
522
+ T623General logarithm functionsYES
523
+ T624Common logarithm functionsYES
524
+ T625LISTAGGNO
503
525
T631IN predicate with one list elementYES
504
526
T641Multiple column assignmentNOonly some syntax variants supported
505
527
T651SQL-schema statements in SQL routinesYES
506
528
T652SQL-dynamic statements in SQL routinesNO
507
529
T653SQL-schema statements in external routinesNO
508
530
T654SQL-dynamic statements in external routinesNO
509
531
T655Cyclically dependent routinesYES
532
+ T811Basic SQL/JSON constructor functionsNO
533
+ T812SQL/JSON: JSON_OBJECTAGGNO
534
+ T813SQL/JSON: JSON_ARRAYAGG with ORDER BYNO
535
+ T814Colon in JSON_OBJECT or JSON_OBJECTAGGNO
536
+ T821Basic SQL/JSON query operatorsNO
537
+ T822SQL/JSON: IS JSON WITH UNIQUE KEYS predicateNO
538
+ T823SQL/JSON: PASSING clauseNO
539
+ T824JSON_TABLE: specific PLAN clauseNO
540
+ T825SQL/JSON: ON EMPTY and ON ERROR clausesNO
541
+ T826General value expression in ON ERROR or ON EMPTY clausesNO
542
+ T827JSON_TABLE: sibling NESTED COLUMNS clausesNO
543
+ T828JSON_QUERYNO
544
+ T829JSON_QUERY: array wrapper optionsNO
545
+ T830Enforcing unique keys in SQL/JSON constructor functionsNO
546
+ T831SQL/JSON path language: strict modeNO
547
+ T832SQL/JSON path language: item methodNO
548
+ T833SQL/JSON path language: multiple subscriptsNO
549
+ T834SQL/JSON path language: wildcard member accessorNO
550
+ T835SQL/JSON path language: filter expressionsNO
551
+ T836SQL/JSON path language: starts with predicateNO
552
+ T837SQL/JSON path language: regex_like predicateNO
553
+ T838JSON_TABLE: PLAN DEFAULT clauseNO
554
+ T839Formatted cast of datetimes to/from character stringsNO
510
555
M001DatalinksNO
511
556
M002Datalinks via SQL/CLINO
512
557
M003Datalinks via Embedded SQLNO