Type Predicate Functions This section provides reference information for type predicate functions in TiDB Cloud Lake. These functions enable type checking, validation, and conversion of JSON values.
Type Checking Function Description Example IS_ARRAY Checks if a JSON value is an array IS_ARRAY('[1,2,3]') → trueIS_OBJECT Checks if a JSON value is an object IS_OBJECT('{"key":"value"}') → trueIS_STRING Checks if a JSON value is a string IS_STRING('"hello"') → trueIS_INTEGER Checks if a JSON value is an integer IS_INTEGER('42') → trueIS_FLOAT Checks if a JSON value is a floating-point number IS_FLOAT('3.14') → trueIS_BOOLEAN Checks if a JSON value is a boolean IS_BOOLEAN('true') → trueIS_NULL_VALUE Checks if a JSON value is null IS_NULL_VALUE('null') → true