Optional Features in SQL-99

The following table lists all the features outside Core SQL and whether they can be validated or not.

Mimer SQL-99 Validator can validate almost all SQL features, but sometimes information about a feature can only be determined by having access to an existing database.

Feature IDFeature NameValidated
B031Basic dynamic SQLYes
B032Extended dynamic SQLYes
B033Untyped SQL-invoked function argumentsYes
B041Extensions to embedded SQL exception declarationsYes
B051Enhanced execution rightsYes
F032CASCADE drop behaviorYes
F033ALTER TABLE statement: DROP COLUMN clauseYes
F034Extended REVOKE statementYes
F052Intervals and datetime arithmeticYes
F053OVERLAPS predicateYes
F111Isolation levels other than SERIALIZABLEYes
F121Basic diagnostics managementYes
F171Multiple schemas per userYes
F191Referential delete actionsYes
F222INSERT statement: DEFAULT VALUES clauseYes
F231Privilege tablesNo (Catalog Lookup)
F251Domain supportYes
F271Compound character literalsYes
F281LIKE enhancementsYes
F291UNIQUE predicateYes
F301CORRESPONDING in query expressionsYes
F302INTERSECT table operatorYes
F304EXCEPT ALL table operatorYes
F321User authorizationYes
F341Usage tablesNo (Catalog Lookup)
F361Subprogram supportNo (Embedded SQL)
F381Extended schema manipulationYes
F391Long identifiersYes
F401Extended joined tableYes
F411Time zone specificationYes
F421National characterYes
F431Read-only scrollable cursorsYes
F441Extended set function supportYes
F442Mixed column references in set functionsNo (Catalog Lookup)
F451Character set definitionYes
F461Named character setsYes
F491Constraint managementYes
F502Enhanced documentation tablesNo (Catalog Lookup)
F531Temporary tablesYes
F555Enhanced seconds precisionYes
F561Full value expressionsYes
F571Truth value testsYes
F591Derived tablesYes
F611Indicator data typesNo (Catalog Lookup)
F641Row and table constructorsYes
F651Catalog name qualifiersYes
F661Simple tablesYes
F671Subqueries in CHECKYes
F691Collation and translationYes
F701Referential update actionsYes
F711ALTER domainYes
F721Deferrable constraintsYes
F731INSERT column privilegesYes
F741Referential MATCH typesYes
F751View CHECK enhancementsYes
F761Session managementYes
F771Connection managementYes
F781Self-referencing operationsYes
F791Insensitive cursorsYes
F801Full set functionYes
F813Extended flaggingNo (Catalog Lookup)
F821Local table referencesYes
F831Full cursor updateYes
S023Basic structured typesYes
S024Enhanced structured typesYes
S041Basic reference typesYes
S043Enhanced reference typesYes
S051Create table of typeYes
S071SQL paths in function and type name resolutionYes
S091Basic array supportYes
S092Arrays of user-defined typesYes
S094Arrays of reference typesYes
S111ONLY in query expressionsYes
S151Type predicateYes
S161Subtype treatmentYes
S201SQL-invoked routines on arraysNo (Catalog Lookup)
S211User-defined cast functionsYes
S231Structured type locatorsYes
S232Array locatorsYes
S241Transform functionsYes
S251User-defined orderingsYes
S261Specific type methodYes
T011Timestamp in Information SchemaNo (Catalog Lookup)
T031BOOLEAN data typeYes
T041Basic LOB data type supportYes
T042Extended LOB data type supportNo (Catalog Lookup)
T051Row typesYes
T111Updatable joins, unions, and columnsNo (Catalog Lookup)
T121WITH (excluding RECURSIVE) in query expressionYes
T131Recursive queryYes
T141SIMILAR predicateYes
T151DISTINCT predicateYes
T171LIKE clause in table definitionYes
T191Referential action RESTRICTYes
T201Comparable data types for referential constraintsNo (Catalog Lookup)
T211Basic trigger capabilityYes
T212Enhanced trigger capabilityYes
T231Sensitive cursorsYes
T251SET TRANSACTION statement: LOCAL optionYes
T261Chained transactionsYes
T281SELECT privilege with column granularityYes
T301Functional dependenciesYes
T312OVERLAY functionYes
T322Overloading of SQL-invoked functions and proceduresNo (Catalog Lookup)
T323Explicit security for external routinesYes
T331Basic rolesYes
T332Extended rolesYes
T351Bracketed SQL comments (/*...*/ comments)Yes
T431Extended grouping capabilitiesYes
T441ABS and MOD functionsNo (Catalog Lookup)
T461Symmetric BETWEEN predicateYes
T471Result sets return valueYes
T491LATERAL derived tableYes
T501Enhanced EXISTS predicateYes
T511Transaction countsYes
T551Optional key words for default syntaxYes
T561Holdable locatorsYes
T571Array-returning external SQL-invoked functionsNo (Catalog Lookup)
T581Regular expression substring functionYes
T591UNIQUE constraints of possibly null columnsNo
T611Elementary OLAP operationsYes
T612Advanced OLAP operationsYes
T621Enhanced numeric functionsYes
T631IN predicate with one list elementYes
P001Stored modulesYes
P002Computational completenessYes
P003Information Schema viewsNo (Catalog Lookup)
V001Mimer SQL extensionYes


Powered by Mimer SQL

Powered by Mimer SQL