Int and UInt ​

CoordinatorDB provides signed (Int) and unsigned (UInt) integers from 8 through 256 bits. Use a width that contains the values your column must accept. Unsigned types reject negative values.

Syntax ​

Int8 | Int16 | Int32 | Int64 | Int128 | Int256
UInt8 | UInt16 | UInt32 | UInt64 | UInt128 | UInt256

Integer Ranges ​

A signed N-bit integer ranges from -2^(N-1) through 2^(N-1)-1. An unsigned N-bit integer ranges from 0 through 2^N-1.

Conversion and overflow ​

Inserts, updates, casts, defaults and generated expressions must fit the declared range. Out-of-range conversion raises NUMERIC_OVERFLOW; values do not wrap around. Fractional numeric input truncates toward zero before range checking.

Use quoted decimal text for wide values when the calling language or a JSON client cannot preserve a large integer exactly. Native wide integers support exact numeric operations; the legacy INTEGER declaration instead follows SQLite-style affinity.

A top-level column accepts SQL NULL unless it declares NOT NULL.

Examples ​

Creating a typed counter ​

CREATE TABLE counters(id UInt32 PRIMARY KEY, attempts UInt8 NOT NULL);
INSERT INTO counters VALUES (1, 255);

SELECT id, attempts
FROM counters
FORMAT csv;

1,255

An attempt to store 256 in attempts raises NUMERIC_OVERFLOW.

Converting a wide unsigned value ​

SELECT CAST('18446744073709551615' AS UInt64),
       CAST('340282366920938463463374607431768211455' AS UInt128)
FORMAT csv;

18446744073709551615,340282366920938463463374607431768211455

Truncating fractional input ​

SELECT CAST(12.9 AS Int8), CAST(-12.9 AS Int8)
FORMAT csv;

12,-12

See Decimal for exact fractional values and floating-point types for approximate values.