IS_BOOLEAN function

Checks whether a value is a BOOLEAN. The IS_BOOLEAN function returns true for constant JSON Booleans. The function returns false for any other values, including null.

Syntax

IS_BOOLEAN(super_expression)

Arguments

super_expression

A SUPER expression or column.

Return type

BOOLEAN

Examples

To check if TRUE is a BOOLEAN using the IS_BOOLEAN function, use the following example.

CREATE TABLE t(s SUPER);

INSERT INTO t VALUES (TRUE);

SELECT s, IS_BOOLEAN(s) FROM t;

+------+------------+
|  s   | is_boolean |
+------+------------+
| true | true       |
+------+------------+