@@ -264,7 +264,7 @@ F401Extended joined table01NATURAL JOINYES
264
264
F401Extended joined table02FULL OUTER JOINYES
265
265
F401Extended joined table04CROSS JOINYES
266
266
F402Named column joins for LOBs, arrays, and multisetsYES
267
- F403Partitionedjoined tablesNO
267
+ F403Partitionedjoin tablesNO
268
268
F404Range variable for common column namesYES
269
269
F411Time zone specificationYESdifferences regarding literal interpretation
270
270
F421National characterYES
@@ -297,7 +297,7 @@ F611Indicator data typesYES
297
297
F641Row and table constructorsYES
298
298
F651Catalog name qualifiersYES
299
299
F661Simple tablesYES
300
- F671Subqueries in CHECKNOintentionally omitted
300
+ F671Subqueries in CHECK constraints NOintentionally omitted
301
301
F672Retrospective check constraintsYES
302
302
F673Reads SQL-data routine invocations in CHECK constraintsNO
303
303
F690Collation supportYESbut no character set support
@@ -397,13 +397,13 @@ S281Nested collection typesNO
397
397
S291Unique constraint on entire rowNO
398
398
S301Enhanced UNNESTYES
399
399
S401Distinct types based on array typesNO
400
- S402Distinct types based ondistinct typesNO
400
+ S402Distinct types based onmultiset typesNO
401
401
S403ARRAY_MAX_CARDINALITYNO
402
402
S404TRIM_ARRAYYES
403
403
T011Timestamp in Information SchemaNO
404
404
T021BINARY and VARBINARY data typesNO
405
405
T022Advanced support for BINARY and VARBINARY data typesNO
406
- T023Compound binaryliteral NO
406
+ T023Compound binaryliterals NO
407
407
T024Spaces in binary literalsNO
408
408
T031BOOLEAN data typeYES
409
409
T041Basic LOB data type supportNO
@@ -437,7 +437,7 @@ T174Identity columnsYES
437
437
T175Generated columnsNOmostly supported
438
438
T176Sequence generator supportNOsupported except for NEXT VALUE FOR
439
439
T177Sequence generator support: simple restart optionYES
440
- T178Identity columns: simple restart optionYES
440
+ T178Identity columns: simple restart optionYES
441
441
T180System-versioned tablesNO
442
442
T181Application-time period tablesNO
443
443
T191Referential action RESTRICTYES
@@ -511,7 +511,7 @@ T613SamplingYES
511
511
T614NTILE functionYES
512
512
T615LEAD and LAG functionsYES
513
513
T616Null treatment option for LEAD and LAG functionsNO
514
- T617FIRST_VALUE and LAST_VALUEfunction YES
514
+ T617FIRST_VALUE and LAST_VALUEfunctions YES
515
515
T618NTH_VALUE functionNOfunction exists, but some options missing
516
516
T619Nested window functionsNO
517
517
T620WINDOW clause: GROUPS optionYES
@@ -558,23 +558,23 @@ M005Foreign schema supportNO
558
558
M006GetSQLString routineNO
559
559
M007TransmitRequestNO
560
560
M009GetOpts and GetStatistics routinesNO
561
- M010Foreign data wrapper supportNOdifferent API
561
+ M010Foreign- data wrapper supportNOdifferent API
562
562
M011Datalinks via AdaNO
563
563
M012Datalinks via CNO
564
564
M013Datalinks via COBOLNO
565
565
M014Datalinks via FortranNO
566
566
M015Datalinks via MNO
567
567
M016Datalinks via PascalNO
568
568
M017Datalinks via PL/INO
569
- M018Foreign data wrapper interface routines in AdaNO
570
- M019Foreign data wrapper interface routines in CNOdifferent API
571
- M020Foreign data wrapper interface routines in COBOLNO
572
- M021Foreign data wrapper interface routines in FortranNO
573
- M022Foreign data wrapper interface routines in MUMPSNO
574
- M023Foreign data wrapper interface routines in PascalNO
575
- M024Foreign data wrapper interface routines in PL/INO
569
+ M018Foreign- data wrapper interface routines in AdaNO
570
+ M019Foreign- data wrapper interface routines in CNOdifferent API
571
+ M020Foreign- data wrapper interface routines in COBOLNO
572
+ M021Foreign- data wrapper interface routines in FortranNO
573
+ M022Foreign- data wrapper interface routines in MUMPSNO
574
+ M023Foreign- data wrapper interface routines in PascalNO
575
+ M024Foreign- data wrapper interface routines in PL/INO
576
576
M030SQL-server foreign data supportNO
577
- M031Foreign data wrapper general routinesNO
577
+ M031Foreign- data wrapper general routinesNO
578
578
X010XML typeYES
579
579
X011Arrays of XML typeYES
580
580
X012Multisets of XML typeNO
@@ -593,7 +593,7 @@ X036XMLCommentYES
593
593
X037XMLPIYES
594
594
X038XMLTextNO
595
595
X040Basic table mappingYES
596
- X041Basic table mapping:nulls absentYES
596
+ X041Basic table mapping:null absentYES
597
597
X042Basic table mapping: null as nilYES
598
598
X043Basic table mapping: table as forestYES
599
599
X044Basic table mapping: table as elementYES
@@ -603,7 +603,7 @@ X047Basic table mapping: metadata mappingYES
603
603
X048Basic table mapping: base64 encoding of binary stringsYES
604
604
X049Basic table mapping: hex encoding of binary stringsYES
605
605
X050Advanced table mappingYES
606
- X051Advanced table mapping:nulls absentYES
606
+ X051Advanced table mapping:null absentYES
607
607
X052Advanced table mapping: null as nilYES
608
608
X053Advanced table mapping: table as forestYES
609
609
X054Advanced table mapping: table as elementYES
@@ -614,16 +614,16 @@ X058Advanced table mapping: base64 encoding of binary stringsYES
614
614
X059Advanced table mapping: hex encoding of binary stringsYES
615
615
X060XMLParse: character string input and CONTENT optionYES
616
616
X061XMLParse: character string input and DOCUMENT optionYES
617
- X065XMLParse:BLOB input and CONTENT optionNO
618
- X066XMLParse:BLOB input and DOCUMENT optionNO
617
+ X065XMLParse:binary string input and CONTENT optionNO
618
+ X066XMLParse:binary string input and DOCUMENT optionNO
619
619
X068XMLSerialize: BOMNO
620
620
X069XMLSerialize: INDENTNO
621
621
X070XMLSerialize: character string serialization and CONTENT optionYES
622
622
X071XMLSerialize: character string serialization and DOCUMENT optionYES
623
623
X072XMLSerialize: character string serializationYES
624
- X073XMLSerialize:BLOB serialization and CONTENT optionNO
625
- X074XMLSerialize:BLOB serialization and DOCUMENT optionNO
626
- X075XMLSerialize:BLOB serializationNO
624
+ X073XMLSerialize:binary string serialization and CONTENT optionNO
625
+ X074XMLSerialize:binary string serialization and DOCUMENT optionNO
626
+ X075XMLSerialize:binary string serializationNO
627
627
X076XMLSerialize: VERSIONNO
628
628
X077XMLSerialize: explicit ENCODING optionNO
629
629
X078XMLSerialize: explicit XML declarationNO
@@ -656,9 +656,9 @@ X142IS VALID predicate: ACCORDING TO clauseNO
656
656
X143IS VALID predicate: ELEMENT clauseNO
657
657
X144IS VALID predicate: schema locationNO
658
658
X145IS VALID predicate outside check constraintsNO
659
- X151IS VALID predicate with DOCUMENT optionNO
660
- X152IS VALID predicate with CONTENT optionNO
661
- X153IS VALID predicate with SEQUENCE optionNO
659
+ X151IS VALID predicate: with DOCUMENT optionNO
660
+ X152IS VALID predicate: with CONTENT optionNO
661
+ X153IS VALID predicate: with SEQUENCE optionNO
662
662
X155IS VALID predicate: NAMESPACE without ELEMENT clauseNO
663
663
X157IS VALID predicate: NO NAMESPACE with ELEMENT clauseNO
664
664
X160Basic Information Schema for registered XML SchemasNO