Integer Types

Integer Types#

INT      -- 32-bit signed
BIGINT   -- 64-bit signed
HUGEINT  -- 128-bit signed

INT maps to the internal 32-bit signed integer (I32). BIGINT maps to the 64-bit signed integer (I64). HUGEINT maps to the internal 128-bit signed integer (I128).

All integer literals in SQL are parsed as I64 by default; literals outside the I64 range are rejected by the parser. The parser performs no per-column range checking: an oversized value written to a narrower integer column is converted by the runtime’s truncating cast rules (for example, 3000000000 written to an INT column wraps to -1294967296).