@@ -229,7 +229,7 @@ F311Schema definition statement02CREATE TABLE for persistent base tablesYES
229
229
F311Schema definition statement03CREATE VIEWYES
230
230
F311Schema definition statement04CREATE VIEW: WITH CHECK OPTIONYES
231
231
F311Schema definition statement05GRANT statementYES
232
- F312MERGE statementNOConsider INSERT ... ON CONFLICT DO UPDATE
232
+ F312MERGE statementNOconsider INSERT ... ON CONFLICT DO UPDATE
233
233
F313Enhanced MERGE statementNO
234
234
F314MERGE statement with DELETE branchNO
235
235
F321User authorizationYES
@@ -383,7 +383,7 @@ S274Multisets of reference typesNO
383
383
S275Advanced multiset supportNO
384
384
S281Nested collection typesNO
385
385
S291Unique constraint on entire rowNO
386
- S301Enhanced UNNESTNO
386
+ S301Enhanced UNNESTYES
387
387
S401Distinct types based on array typesNO
388
388
S402Distinct types based on distinct typesNO
389
389
S403ARRAY_MAX_CARDINALITYNO
@@ -481,16 +481,15 @@ T501Enhanced EXISTS predicateYES
481
481
T502Period predicatesNO
482
482
T511Transaction countsNO
483
483
T521Named arguments in CALL statementNO
484
- T522Default values for IN parameters of SQL-invoked proceduresNO
485
- T541Updatable table referencesNO
484
+ T522Default values for IN parameters of SQL-invoked proceduresNOsupported except DEFAULT key word in invocation
486
485
T551Optional key words for default syntaxYES
487
486
T561Holdable locatorsNO
488
487
T571Array-returning external SQL-invoked functionsNO
489
488
T572Multiset-returning external SQL-invoked functionsNO
490
489
T581Regular expression substring functionYES
491
490
T591UNIQUE constraints of possibly null columnsYES
492
491
T601Local cursor referencesNO
493
- T611Elementary OLAP operationsNOmost forms supported
492
+ T611Elementary OLAP operationsYES
494
493
T612Advanced OLAP operationsNOsome forms supported
495
494
T613SamplingYES
496
495
T614NTILE functionYES