v.25.11Improvement
Add support for inverse IS DISTINCT
EnhancedIS NOT DISTINCT FROM(<=>) operator: added support for inverseIS DISTINCT FROM, support compatible numeric operands of different types (e.g.,Nullable(UInt32)andNullable(Int64)). Resolves #86763. #87581 (yanglongwei).
Why it matters
This feature resolves compatibility issues when comparing nullable numeric types of different sizes or signedness using theIS NOT DISTINCT FROM and IS DISTINCT FROM operators. It improves type flexibility and correctness of equality comparisons, enabling users to write more robust and type-safe queries without manual type casting.How to use it
Users can directly use theIS NOT DISTINCT FROM (<=>) and IS DISTINCT FROM operators in their SQL queries with nullable numeric columns of different compatible types. No additional configuration or setup is needed.