v.23.2Improvement

ClickHouse Client Enhances Fuzzy Search with Exact Matching Algorithm

ClickHouse Client: Use "exact" matching for fuzzy search, which has correct case ignorance and more appropriate algorithm for matching SQL queries. #46000 (Azat Khuzhin).
ClickHouse Client now supports "exact" matching mode for fuzzy search, providing accurate case-insensitive matching and a more appropriate algorithm for matching SQL queries.

Why it matters

This feature improves the usability of fuzzy search in the ClickHouse client by addressing case sensitivity issues and enhancing the relevance of matches when searching for SQL queries. It enables users to find queries more efficiently and precisely.

How to use it

To use this feature, enable the "exact" matching mode in the ClickHouse client fuzzy search settings. This mode ensures case-insensitive search with an optimized matching algorithm suited for SQL query search scenarios.