v.22.7New Feature

Functions Updated to Accept Non-Const Arguments in ClickHouse

Official CH changelog text
Functions multiMatchAny, multiMatchAnyIndex, multiMatchAllIndices and their fuzzy variants now accept non-const pattern array argument. #38485 (Robert Schulze). SQL function multiSearchAllPositions now accepts non-const needle arguments. #39167 (Robert Schulze).
Functions multiMatchAny, multiMatchAnyIndex, multiMatchAllIndices and their fuzzy variants, as well as multiSearchAllPositions, now support non-const pattern or needle array arguments.

Why it matters

Previously, these functions required constant array arguments for patterns or needles, limiting their flexibility. Allowing non-const arrays enables dynamic inputs and more versatile query construction, improving usability and broadening use cases.

How to use it

Simply use the functions multiMatchAny, multiMatchAnyIndex, multiMatchAllIndices, their fuzzy variants, and multiSearchAllPositions as before but now pass non-const (dynamic) arrays as pattern or needle arguments without restrictions.

Related resources

PreviousNext