v.25.12New Feature

Add support for has

Add support for has function to use primary key and data skipping indexes when first argument is constant array. Closes #90980. #91023 (Nihal Z. Miaji).
Add support for the has function to utilize primary key and data skipping indexes when its first argument is a constant array.

Why it matters

This feature improves query performance by enabling the has function to leverage primary key and data skipping indexes for constant arrays, allowing more efficient data filtering and reducing query execution time.

How to use it

Use the has function with a constant array as the first argument in your queries. The ClickHouse engine will automatically apply primary key and data skipping indexes to optimize query performance without any additional configuration required.