BOOLEAN (Boolean)

While all RDBMS support BOOLEAN expressions in the form of a org.jooq.Condition, not all RDBMS support Column expressions of type BOOLEAN. If such boolean type support is unavailable in a dialect, jOOQ will just map the type to INTEGER (Integer) with possible values being 0 and 1.

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

CREATE TABLE t (
  c bit
)

CREATE TABLE t (
  c bit NULL
)

CREATE TABLE t (
  c boolean
)

CREATE TABLE t (
  c bool
)

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

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

CREATE TABLE t (
  c smallint
)

CREATE TABLE t (
  c number
)

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

cast(field("c"), BOOLEAN)

cbool(c)

CAST(c AS bit)

CAST(c AS unsigned)

CAST(c AS boolean)

CAST(c AS bool)

CAST(c AS Nullable(boolean))

CAST(c AS smallint)

CAST(c AS number(1))

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