The following table lists all the optional features in SQL-2003 and
whether they can be validated or not.
The Mimer SQL 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 ID | Feature Name | Validated |
|---|
| B031 | Basic dynamic SQL | Yes |
| B032 | Extended dynamic SQL | Yes |
| B033 | Untyped SQL-invoked function arguments | Yes |
| B034 | Dynamic specification of cursor attributes | Yes |
| B041 | Extensions to embedded SQL exception declarations | Yes |
| B051 | Enhanced execution rights | Yes |
| F032 | CASCADE drop behavior | Yes |
| F033 | ALTER TABLE statement: DROP COLUMN clause | Yes |
| F034 | Extended REVOKE statement | Yes |
| F052 | Intervals and datetime arithmetic | Yes |
| F053 | OVERLAPS predicate | Yes |
| F111 | Isolation levels other than SERIALIZABLE | Yes |
| F121 | Basic diagnostics management | Yes |
| F171 | Multiple schemas per user | Yes |
| F191 | Referential delete actions | Yes |
| F222 | INSERT statement: DEFAULT VALUES clause | Yes |
| F231 | Privilege tables | No (Catalog Lookup) |
| F251 | Domain support | Yes |
| F262 | Extended CASE expression | Yes |
| F271 | Compound character literals | Yes |
| F281 | LIKE enhancements | Yes |
| F291 | UNIQUE predicate | Yes |
| F301 | CORRESPONDING in query expressions | Yes |
| F302 | INTERSECT table operator | Yes |
| F304 | EXCEPT ALL table operator | Yes |
| F312 | MERGE statement | Yes |
| F321 | User authorization | Yes |
| F341 | Usage tables | No (Catalog Lookup) |
| F361 | Subprogram support | No (Embedded SQL) |
| F381 | Extended schema manipulation | Yes |
| F391 | Long identifiers | Yes |
| F392 | Unicode escapes in identifiers | Yes |
| F393 | Unicode escapes in literals | Yes |
| F401 | Extended joined table | Yes |
| F402 | Named column joins for LOBs, arrays, and multisets | No (Catalog Lookup) |
| F411 | Time zone specification | Yes |
| F421 | National character | Yes |
| F431 | Read-only scrollable cursors | Yes |
| F441 | Extended set function support | Yes |
| F442 | Mixed column references in set functions | No (Catalog Lookup) |
| F451 | Character set definition | Yes |
| F461 | Named character sets | Yes |
| F491 | Constraint management | Yes |
| F502 | Enhanced documentation tables | No (Catalog Lookup) |
| F521 | Assertions | Yes |
| F531 | Temporary tables | Yes |
| F555 | Enhanced seconds precision | Yes |
| F561 | Full value expressions | Yes |
| F571 | Truth value tests | Yes |
| F591 | Derived tables | Yes |
| F611 | Indicator data types | No (Catalog Lookup) |
| F641 | Row and table constructors | Yes |
| F651 | Catalog name qualifiers | Yes |
| F661 | Simple tables | Yes |
| F671 | Subqueries in CHECK | Yes |
| F672 | Retrospective check constraints | Yes |
| F691 | Collation and translation | Yes |
| F692 | Enhanced collation support | Yes |
| F693 | SQL-session and client module collations | Yes |
| F701 | Referential update actions | Yes |
| F711 | ALTER domain | Yes |
| F721 | Deferrable constraints | Yes |
| F731 | INSERT column privileges | Yes |
| F741 | Referential MATCH types | Yes |
| F751 | View CHECK enhancements | Yes |
| F761 | Session management | Yes |
| F771 | Connection management | Yes |
| F781 | Self-referencing operations | Yes |
| F791 | Insensitive cursors | Yes |
| F801 | Full set function | Yes |
| F813 | Extended flagging | No (Catalog Lookup) |
| F821 | Local table references | Yes |
| F831 | Full cursor update | Yes |
| S023 | Basic structured types | Yes |
| S024 | Enhanced structured types | Yes |
| S025 | Final structured types | Yes |
| S026 | Self-referencing structured types | Yes |
| S027 | Create method by specific method name | Yes |
| S028 | Permutable UDT options list | Yes |
| S041 | Basic reference types | Yes |
| S043 | Enhanced reference types | Yes |
| S051 | Create table of type | Yes |
| S071 | SQL paths in function and type name resolution | Yes |
| S081 | Subtables | Yes |
| S091 | Basic array support | Yes |
| S092 | Arrays of user-defined types | Yes |
| S094 | Arrays of reference types | Yes |
| S095 | Array constructors by query | Yes |
| S096 | Optional array bounds | Yes |
| S097 | Array element assignment | Yes |
| S111 | ONLY in query expressions | Yes |
| S151 | Type predicate | Yes |
| S161 | Subtype treatment | Yes |
| S162 | Subtype treatment for references | Yes |
| S201 | SQL-invoked routines on arrays | No (Catalog Lookup) |
| S202 | SQL-invoked routines on multisets | No (Catalog Lookup) |
| S211 | User-defined cast functions | Yes |
| S231 | Structured type locators | Yes |
| S232 | Array locators | Yes |
| S233 | Multiset locators | Yes |
| S241 | Transform functions | Yes |
| S242 | Alter transform statement | Yes |
| S251 | User-defined orderings | Yes |
| S261 | Specific type method | Yes |
| S271 | Basic multiset support | Yes |
| S272 | Multisets of user-defined types | Yes |
| S274 | Multisets of reference types | Yes |
| S275 | Advanced multiset support | Yes |
| S281 | Nested collection types | Yes |
| T011 | Timestamp in Information Schema | No (Catalog Lookup) |
| T031 | BOOLEAN data type | Yes |
| T041 | Basic LOB data type support | Yes |
| T042 | Extended LOB data type support | No (Catalog Lookup) |
| T051 | Row types | Yes |
| T052 | MAX and MIN for row types | No (Catalog Lookup) |
| T053 | Explicit aliases for all fields reference | Yes |
| T061 | UCS support | Yes |
| T071 | BIGINT data type | Yes |
| T111 | Updatable joins, unions, and columns | No (Catalog Lookup) |
| T121 | WITH (excluding RECURSIVE) in query expression | Yes |
| T131 | Recursive query | Yes |
| T141 | SIMILAR predicate | Yes |
| T151 | DISTINCT predicate | Yes |
| T171 | LIKE clause in table definition | Yes |
| T172 | AS subquery clause in table definition | Yes |
| T173 | Extended LIKE clause in table definition | Yes |
| T174 | Identity columns | Yes |
| T175 | Generated columns | Yes |
| T176 | Sequence generator support | Yes |
| T191 | Referential action RESTRICT | Yes |
| T201 | Comparable data types for referential constraints | No (Catalog Lookup) |
| T211 | Basic trigger capability | Yes |
| T212 | Enhanced trigger capability | Yes |
| T231 | Sensitive cursors | Yes |
| T241 | START TRANSACTION statement | Yes |
| T242 | Optional transaction modes in START TRANSACTION | Yes |
| T251 | SET TRANSACTION statement: LOCAL option | Yes |
| T261 | Chained transactions | Yes |
| T271 | Savepoints | Yes |
| T272 | Enhanced savepoint management | Yes |
| T281 | SELECT privilege with column granularity | Yes |
| T301 | Functional dependencies | Yes |
| T312 | OVERLAY function | Yes |
| T322 | Overloading of SQL-invoked functions and procedures | No (Catalog Lookup) |
| T323 | Explicit security for external routines | Yes |
| T324 | Explicit security for SQL routines | Yes |
| T325 | Qualified SQL parameter references | No (Catalog Lookup) |
| T326 | Table functions | Yes |
| T331 | Basic roles | Yes |
| T332 | Extended roles | Yes |
| T351 | Bracketed SQL comments (/*...*/ comments) | Yes |
| T431 | Extended grouping capabilities | Yes |
| T432 | Nested and concatenated GROUPING SETS | Yes |
| T433 | Multiargument GROUPING function | Yes |
| T434 | GROUP BY DISINCT | Yes |
| T441 | ABS and MOD functions | No (Catalog Lookup) |
| T461 | Symmetric BETWEEN predicate | Yes |
| T471 | Result sets return value | Yes |
| T491 | LATERAL derived table | Yes |
| T501 | Enhanced EXISTS predicate | Yes |
| T511 | Transaction counts | Yes |
| T551 | Optional key words for default syntax | Yes |
| T561 | Holdable locators | Yes |
| T571 | Array-returning external SQL-invoked functions | No (Catalog Lookup) |
| T572 | Multiset-returning external SQL-invoked functions | No (Catalog Lookup) |
| T581 | Regular expression substring function | Yes |
| T591 | UNIQUE constraints of possibly null columns | No |
| T601 | Local cursor references | Yes |
| T611 | Elementary OLAP operations | Yes |
| T612 | Advanced OLAP operations | Yes |
| T613 | Sampling | Yes |
| T621 | Enhanced numeric functions | Yes |
| T631 | IN predicate with one list element | Yes |
| T641 | Multiple column assignment | Yes |
| T651 | SQL-schema statements in SQL routines | Yes |
| T652 | SQL-dynamic statements in SQL routines | Yes |
| P001 | Stored modules | Yes |
| P002 | Computational completeness | Yes |
| P003 | Information Schema views | No (Catalog Lookup) |
| P004 | Extended CASE statement | Yes |
| P005 | Qualified SQL variable references | No (Catalog Lookup) |
| P006 | Multiple assignment | Yes |
| P007 | Enhanced diagnostics management | Yes |
| V001 | Mimer SQL extension | Yes |
Mpm Home
Printer friendly
