BIGINT UNSIGNED (ULong)

If unsigned support is unavailable in a dialect, jOOQ will just map the type to the next higher integer type DECIMAL INTEGER (BigInteger).

createTable("t").column("c", BIGINTUNSIGNED)

CREATE TABLE t (
  c numeric
)

CREATE TABLE t (
  c unsigned bigint NULL
)

CREATE TABLE t (
  c bigint unsigned
)

CREATE TABLE t (
  c decimal
)

CREATE TABLE t (
  c Nullable(UInt64)
)
ENGINE Log()

CREATE TABLE t (
  c bigint unsigned
)
TBLPROPERTIES(
  'delta.columnMapping.mode' = 'name',
  'delta.feature.allowColumnDefaults' = 'supported'
)

CREATE TABLE t (
  c ubigint
)

CREATE TABLE t (
  c number
)

CREATE TABLE t (
  c number(20)
)

Generated with jOOQ 3.21. Support in older jOOQ versions may differ. Translate your own SQL on our website

cast(field("c"), BIGINTUNSIGNED)

cdec(c)

CAST(c AS unsigned bigint)

CAST(c AS unsigned)

CAST(c AS decimal)

CAST(c AS bigint unsigned)

CAST(c AS Nullable(UInt64))

CAST(c AS decimal(20))

CAST(c AS ubigint)

CAST(c AS number)

CAST(c AS varchar(20))

CAST(c AS number(20))

CAST(c AS numeric)

Generated with jOOQ 3.21. Support in older jOOQ versions may differ. Translate your own SQL on our website