v.20.5New Feature

Allow Comparison of Numbers with Constant Strings in ClickHouse

Official CH changelog text
Allow comparison of numbers with constant string in comparison operators, IN and VALUES sections. #11647 (alexey-milovidov).
Enable comparison between numeric columns and constant strings within comparison operators, IN clauses, and VALUES sections in ClickHouse queries.

Why it matters

This feature resolves issues where numeric columns could not be directly compared to constant string literals, enhancing query flexibility and usability by allowing implicit comparison without additional type casting.

How to use it

Users can directly write queries using comparison operators (=, <, >, etc.), IN lists, or VALUES clauses containing constant string literals to compare against numeric columns without needing explicit type conversion.

Related resources

PreviousNext