Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Features Outside Core Supported by Mimer SQL


Feature ID
Feature Name
B021
Direct SQL
B031
Basic dynamic SQL
B032
Extended dynamic SQL
B032-01
<describe input> statement
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
F111-01
READ UNCOMMITTED isolation level
F111-02
READ COMMITTED isolation level
F111-03
REPEATABLE READ isolation level
F121
Basic diagnostics management
F121-01
GET DIAGNOSTICS statement
F121-02
SET TRANSACTION statement: DIAGNOSTICS SIZE clause
F171
Multiple schemas per user
F191
Referential delete actions
F222
INSERT statement: DEFAULT VALUES clause
F251
Domain support
F271
Compound character literals
F281
LIKE enhancements
F291
UNIQUE predicate
F301
CORRESPONDING in query expressions
F302
INTERSECT table operator
F302-01
INTERSECT DISTINCT table operator
F302-02
INTERSECT ALL table operator
F304
EXCEPT ALL table operator
F321
User authorization
F361
Subprogram support
F381
Extended schema manipulation
F381-01
ALTER TABLE statement: ALTER COLUMN clause
F381-02
ALTER TABLE statement: ADD CONSTRAINT clause
F381-03
ALTER TABLE statement: DROP CONSTRAINT clause
F382
Alter column data type
F391
Long identifiers
F401-01
NATURAL JOIN
F401-04
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
F571
Truth value tests
F591
Derived tables
F661
Simple tables
F690
Collation support
F692
Enhanced collation support
F701
Referential update actions
F731
INSERT column privileges
F771
Connection management
F781
Self-referencing operations
F850
Top-level <order by clause> in <query expression>
F851
<order by clause> in subqueries
F852
Top-level <order by clause> in views
F857
Top-level <fetch first clause> in <query expression>
F858
<fetch first clause> in subqueries
F859
Top-level <fetch first clause> in views
F860
dynamic <fetch first row count> in <fetch first clause>
F861
Top-level <result offset clause> in <query expression>
F862
<result offset clause> in subqueries
F864
Top-level <result offset clause> in views
F865
dynamic <offset row count> in <result offset clause>
P006
Multiple assignment
S027
Create method by specific method name
S071
SQL paths in function and type name resolution
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
T121
WITH (excluding RECURSIVE ) in query expression
T122
WITH (excluding RECURSIVE ) in subquery
T151
DISTINCT predicate
T152
DISTINCT predicate with negation
T176
Sequence generator support
T211
Basic trigger capability
T212
Enhanced trigger capability
T213
INSTEAD OF triggers
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


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