Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Features Outside Core Supported by Mimer SQL


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


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX