v.25.4Improvement

Don't parse special Bool values

Don't parse special Bool values in text formats inside Variant type by default. It can be enabled using setting allow_special_bool_values_inside_variant. #76974 (Pavel Kruglov).
By default, ClickHouse no longer parses special Boolean values (such as true, false, TRUE, FALSE) inside the Variant data type when reading text formats.

Why it matters

This change prevents unexpected interpretation of Boolean literals within Variant fields in text-based input formats, ensuring more consistent and predictable handling of Variant data. Users gain finer control over parsing behavior, avoiding potential data discrepancies caused by automatic conversion of special Boolean strings.

How to use it

To enable parsing of special Boolean values inside the Variant type in text formats, set the allow_special_bool_values_inside_variant setting to 1 (true). For example, use:

sql<br>SET allow_special_bool_values_inside_variant = 1<br>