Implement Comparison Operator for Variant Values and Field Insertion, with Default Restrictions on Similar Variant Types

Why it matters

This feature enables direct comparison operations on Variant values, enhancing functionality and usability of the Variant data type. It also ensures proper insertion of Field values into Variant columns, preventing unexpected behaviors. The setting allow_suspicious_variant_types helps avoid accidental creation of conflicting variant types unless explicitly allowed by the user, improving data integrity and schema clarity.

How to use it

Users can utilize comparison operators directly on Variant columns in their queries. To allow creation of Variant types with similar underlying types (which is restricted by default), enable the setting allow_suspicious_variant_types in the ClickHouse server configuration or per session.