v.20.4Improvement

Implement LIKE Operator for FixedString in ClickHouse

Official CH changelog text
Implement operator LIKE for FixedString at left hand side. This is needed to better support TPC-DS queries. #9890 (alexey-milovidov)
Implemented the LIKE operator for FixedString data type on the left-hand side of the expression.

Why it matters

This feature improves support for TPC-DS benchmark queries by allowing LIKE operations where the pattern is compared to a FixedString value. It enables more flexible and efficient query patterns involving fixed-length strings in LIKE expressions.

How to use it

Users can now use the LIKE operator directly with FixedString columns or expressions on the left side, for example:

SELECT * FROM table WHERE fixed_string_column LIKE 'pattern%'

Related resources

PreviousNext