BOOL data type

DDL Syntax

BOOL

Arguments

Argument	Description
BOOL	The BOOL type stores simple Boolean (true/false) values and is used for simple query filtering.

Additional information

Use this table to determine how integer and string values are represented when added to a Boolean column.

data	value	bool
integer	0	0
integer > 0	1	1
string	empty, `0`, `f`, `false`	0
string	other string values	1

Examples

CREATE TABLE with all data types

create table allcoltypes
  (
    _id id,
    intcol int min 0 max 10000,
    boolcol bool,
    timestampcol timestamp timeunit 'ms',
    decimalcol decimal(2),
    stringcol string,
    stringsetcol stringset,
    stringsetcolq stringsetq timequantum 'YMD' ttl '24h',
    idcol id,
    idsetcol idset,
    idsetcolq idsetq timequantum 'YMD' ttl '24h'
  )
  comment 'table containing all column types';