There are four supported integer datatypes, TINYINT (8 bits),
SMALLINT (16 bits), INTEGER (32 bits), and BIGINT (64
bits). These are represented as two's complement values, and
computations on these types obey the standard two's complement
semantics, including overflow.
The legal operations are + (plus, unary and binary), - (minus,
unary and binary), * (multiplication), / (division), %
(modulus).
Division or modulus by zero return NULL.
| Function | Description |
|---|---|
ABS(value) |
return absolute value. |
MOD(left, right) |
integer modulus. Same as left % right. |
Non-deterministic functions, such as RAND are currently not
supported in DBSP.