v.22.8Improvement

Support for Primary Key Analysis and Issue Fixes in Row Policies

Support primary key analysis for row_policy_filter and additional_filter. It also helps fix issues like #37454 . #39826 (Amos Bird).
Support primary key analysis for row_policy_filter and additional_filter in ClickHouse.

Why it matters

This feature enhances query optimization by enabling primary key analysis to be applied to row_policy_filter and additional_filter. It fixes issues related to incorrect or inefficient filtering caused by the lack of primary key insight in these filters, such as the problem described in issue #37454.

How to use it

The feature is applied automatically when using row_policy_filter and additional_filter in your queries or table configurations. There is no additional user action needed beyond defining row-level security policies or additional filters as usual.