Feature ID
|
Feature Name
|
| B021 |
Direct SQL |
| 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 |
| F382 |
Alter column data type |
| F391 |
Long identifiers |
| F401-01 |
NATURAL JOIN |
| F401-04 |
Mimer SQL Experience:
CROSS JOIN |
| 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 |
| P006 |
Mimer SQL Experience:
Multiple assignment |
| S023 |
Mimer SQL Engine:
Basic structured types |
| S024 |
Mimer SQL Engine:
Enhanced structured types |
| S027 |
Create method by specific method name |
| S028 |
Permutable UDT options list |
| S071 |
SQL paths in function and type name resolution |
| T011 |
Timestamp in Information Schema |
| T021 |
BINARY and VARBINARY data types |
| T022 |
Advanced support for BINARY and VARBINARY data types |
| T031 |
BOOLEAN data type |
| T041 |
Basic LOB data type support. Mimer SQL does not support the following sub-features:
T041-03 "POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types" (except SUBSTRING that is supported)
T041-04 "Concatenation of LOB data types"
T041-05 "LOB locator: non-holdable". |
| T071 |
BIGINT data type |
| T176 |
Sequence generator support |
| T211 |
Basic trigger capability |
| T212 |
Enhanced trigger capability |
| T241 |
START TRANSACTION statement |
| T441 |
ABS and MOD functions |
| T461 |
Symmetric BETWEEN predicate |
| 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 |
