Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


Limits


The limits specified for X/Open-95 are lower bounds. Compliant systems should support at least the specified number.

If a box is empty this means the standard does not specify a limit.

LIMIT
Mimer SQL
X/Open-95
Character string length
15000
254
Variable length character string
15000
254
BINARY string length
15000

Variable BINARY string length
15000

DECIMAL precision in digits
45
15
FLOAT precision in digits
45
47 bits
SMALLINT precision in digits
5
5
INTEGER precision in digits
10
10
BIGINT precision in digits
19

REAL precision in digits
7
21 bits
DOUBLE PRECISION precision in digits
16
47 bits
SQLCODE precision in digits
10
9
Fractional precision, in decimal digits, of
TIME seconds component
9
6
Fractional precision, in decimal digits, of TIMESTAMP seconds component
9
6
Fractional precision, in decimal digits, of INTERVAL seconds component
9
6
Leading precision, in decimal digits, for INTERVAL data types
7-12
7
Fractional precision for INTERVAL data types that have a SECOND field
9
6
Number of columns in a table
252
100
Number of columns in an index
32
6
Number of tables referenced in a statement
unlimited 1
10
Number of cursors open simultaneously
unlimited 2
10
Number of columns a single update statement can update
unlimited a
20
Number of nested subqueries
15
9
SQL statement length in bytes
32767
4000
Total length of a row, the sum of
Two bytes for column identification
Lengths of all character fields
Precisions of all numeric fields
16000
2000
Identifier length
128
18
1
There is a limit on the total complexity of an SQL statement.
The specified X/Open limits can safely be handled by Mimer SQL.

2
The limit is only dependent on the amount of virtual memory available to the application.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX