v.25.4Improvement
Don't parse special Bool values
Don't parse specialBoolvalues in text formats insideVarianttype by default. It can be enabled using settingallow_special_bool_values_inside_variant. #76974 (Pavel Kruglov).
Why it matters
This change prevents unexpected interpretation of Boolean literals withinVariant 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 theVariant 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>