@@ -264,7 +264,7 @@ F401Extended joined table01NATURAL JOINYES
264264F401Extended joined table02FULL OUTER JOINYES
265265F401Extended joined table04CROSS JOINYES
266266F402Named column joins for LOBs, arrays, and multisetsYES
267- F403Partitionedjoined tablesNO
267+ F403Partitionedjoin tablesNO
268268F404Range variable for common column namesYES
269269F411Time zone specificationYESdifferences regarding literal interpretation
270270F421National characterYES
@@ -297,7 +297,7 @@ F611Indicator data typesYES
297297F641Row and table constructorsYES
298298F651Catalog name qualifiersYES
299299F661Simple tablesYES
300- F671Subqueries in CHECKNOintentionally omitted
300+ F671Subqueries in CHECK constraints NOintentionally omitted
301301F672Retrospective check constraintsYES
302302F673Reads SQL-data routine invocations in CHECK constraintsNO
303303F690Collation supportYESbut no character set support
@@ -397,13 +397,13 @@ S281Nested collection typesNO
397397S291Unique constraint on entire rowNO
398398S301Enhanced UNNESTYES
399399S401Distinct types based on array typesNO
400- S402Distinct types based ondistinct typesNO
400+ S402Distinct types based onmultiset typesNO
401401S403ARRAY_MAX_CARDINALITYNO
402402S404TRIM_ARRAYYES
403403T011Timestamp in Information SchemaNO
404404T021BINARY and VARBINARY data typesNO
405405T022Advanced support for BINARY and VARBINARY data typesNO
406- T023Compound binaryliteral NO
406+ T023Compound binaryliterals NO
407407T024Spaces in binary literalsNO
408408T031BOOLEAN data typeYES
409409T041Basic LOB data type supportNO
@@ -437,7 +437,7 @@ T174Identity columnsYES
437437T175Generated columnsNOmostly supported
438438T176Sequence generator supportNOsupported except for NEXT VALUE FOR
439439T177Sequence generator support: simple restart optionYES
440- T178Identity columns: simple restart optionYES
440+ T178Identity columns: simple restart optionYES
441441T180System-versioned tablesNO
442442T181Application-time period tablesNO
443443T191Referential action RESTRICTYES
@@ -511,7 +511,7 @@ T613SamplingYES
511511T614NTILE functionYES
512512T615LEAD and LAG functionsYES
513513T616Null treatment option for LEAD and LAG functionsNO
514- T617FIRST_VALUE and LAST_VALUEfunction YES
514+ T617FIRST_VALUE and LAST_VALUEfunctions YES
515515T618NTH_VALUE functionNOfunction exists, but some options missing
516516T619Nested window functionsNO
517517T620WINDOW clause: GROUPS optionYES
@@ -558,23 +558,23 @@ M005Foreign schema supportNO
558558M006GetSQLString routineNO
559559M007TransmitRequestNO
560560M009GetOpts and GetStatistics routinesNO
561- M010Foreign data wrapper supportNOdifferent API
561+ M010Foreign- data wrapper supportNOdifferent API
562562M011Datalinks via AdaNO
563563M012Datalinks via CNO
564564M013Datalinks via COBOLNO
565565M014Datalinks via FortranNO
566566M015Datalinks via MNO
567567M016Datalinks via PascalNO
568568M017Datalinks 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
576576M030SQL-server foreign data supportNO
577- M031Foreign data wrapper general routinesNO
577+ M031Foreign- data wrapper general routinesNO
578578X010XML typeYES
579579X011Arrays of XML typeYES
580580X012Multisets of XML typeNO
@@ -593,7 +593,7 @@ X036XMLCommentYES
593593X037XMLPIYES
594594X038XMLTextNO
595595X040Basic table mappingYES
596- X041Basic table mapping:nulls absentYES
596+ X041Basic table mapping:null absentYES
597597X042Basic table mapping: null as nilYES
598598X043Basic table mapping: table as forestYES
599599X044Basic table mapping: table as elementYES
@@ -603,7 +603,7 @@ X047Basic table mapping: metadata mappingYES
603603X048Basic table mapping: base64 encoding of binary stringsYES
604604X049Basic table mapping: hex encoding of binary stringsYES
605605X050Advanced table mappingYES
606- X051Advanced table mapping:nulls absentYES
606+ X051Advanced table mapping:null absentYES
607607X052Advanced table mapping: null as nilYES
608608X053Advanced table mapping: table as forestYES
609609X054Advanced table mapping: table as elementYES
@@ -614,16 +614,16 @@ X058Advanced table mapping: base64 encoding of binary stringsYES
614614X059Advanced table mapping: hex encoding of binary stringsYES
615615X060XMLParse: character string input and CONTENT optionYES
616616X061XMLParse: 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
619619X068XMLSerialize: BOMNO
620620X069XMLSerialize: INDENTNO
621621X070XMLSerialize: character string serialization and CONTENT optionYES
622622X071XMLSerialize: character string serialization and DOCUMENT optionYES
623623X072XMLSerialize: 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
627627X076XMLSerialize: VERSIONNO
628628X077XMLSerialize: explicit ENCODING optionNO
629629X078XMLSerialize: explicit XML declarationNO
@@ -656,9 +656,9 @@ X142IS VALID predicate: ACCORDING TO clauseNO
656656X143IS VALID predicate: ELEMENT clauseNO
657657X144IS VALID predicate: schema locationNO
658658X145IS 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
662662X155IS VALID predicate: NAMESPACE without ELEMENT clauseNO
663663X157IS VALID predicate: NO NAMESPACE with ELEMENT clauseNO
664664X160Basic Information Schema for registered XML SchemasNO