Feature ID
|
Feature Name
|
| B031 |
Basic dynamic SQL |
| B032 |
Extended dynamic SQL |
| B033 |
Untyped SQL invoked function argument |
| F032 |
CASCADE drop behavior |
| F033 |
ALTER TABLE statement: DROP COLUMN clause |
| F034 |
Extended REVOKE statement |
| F052 |
Intervals and datetime arithmetic |
| F053 |
OVERLAPS predicate |
| F111 |
Isolation levels other than SERIALIZABLE |
| F121 |
Basic diagnostics management |
| F171 |
Multiple schemas per user |
| F191 |
Referential delete actions |
| F222 |
INSERT statement: DEFAULT VALUES clause |
| F231 |
Privilege tables |
| F251 |
Domain support |
| F271 |
Compound character literals |
| F281 |
LIKE enhancements |
| F341 |
Usage tables |
| F361 |
Subprogram support |
| F381 |
Extended schema manipulation |
| F391 |
Long identifiers |
| F421 |
National character |
| F431 |
Read-only scrollable cursors |
| F441 |
Extended set function support |
| F442 |
Mixed column references in set functions |
| F491 |
Constraint management |
| F555 |
Enhanced seconds precision |
| F561 |
Full value expressions |
| F731 |
INSERT column privileges |
| F771 |
Connection management |
| F781 |
Self-referencing operations |
| S071 |
SQL paths in function and type name resolution |
| T011 |
Timestamp in Information Schema |
| T041 |
Basic LOB data type support. Mimer SQL does not support the sub-features T041-03 "POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types", T041-04 "Concatenation of LOB data types", and T041-05 "LOB locator: non-holdable". |
| T071 |
BIGINT data type |
| T191 |
Referential action RESTRICT |
| T211 |
Basic trigger capability |
| T212 |
Enhanced trigger capability |
| T241 |
START TRANSACTION statement |
| T441 |
ABS and MOD functions |
| T501 |
Enhanced EXISTS predicate |
| T551 |
Optional key words for default syntax |
| T591 |
UNIQUE constraints of possibly null columns |
| P001 |
Stored modules |
| P002 |
Computational completeness |
| P003 |
Information Schema views |
