v.23.3Improvement

Support Bool Type in JSONType Function

Official CH changelog text
Support Bool type in JSONType function. Previously Null type was mistakenly returned for bool values. #47046 (Anton Popov).
Support for the Bool data type in the JSONType function has been added. Previously, boolean values were incorrectly identified as Null.

Why it matters

This feature fixes the incorrect type identification in JSONType when encountering boolean values, ensuring boolean JSON values are correctly recognized as Bool instead of Null. This improves accuracy and reliability when analyzing JSON data types.

How to use it

Users can simply use the JSONType function on JSON data containing boolean values to get accurate type identification for Bool values without any additional configuration.

Related resources

PreviousNext