v.25.4Improvement

Fix IN clause type coercion

Official CH changelog text
Fix IN clause type coercion for BFloat16 (i.e. SELECT toBFloat16(1) IN [1, 2, 3]; now returns 1). Closes #78754. #78839 (Raufs Dunamalijevs).
Fix type coercion in the IN clause when using BFloat16 values, ensuring expressions like SELECT toBFloat16(1) IN [1, 2, 3] return the correct boolean result.

Why it matters

This fix resolves incorrect behavior in the IN clause when comparing BFloat16 type values with integers. It ensures proper type coercion so that BFloat16 values are accurately matched within lists, improving query correctness and user confidence in floating-point comparisons.

How to use it

Users can benefit from this fix automatically after upgrading to the version including this patch. No additional configuration or syntax changes are required; the IN clause will now handle BFloat16 type coercion properly by default.

Related resources

PreviousNext