v.25.5Improvement

Add a new field condition to system

Added a new field condition to system table system.query_condition_cache. It stores the plaintext condition whose hash is used as a key in the query condition cache. #78671 (Robert Schulze).
Added a new condition field to the system.query_condition_cache table that stores the plaintext condition corresponding to the cached query condition hash.

Why it matters

This feature enhances the visibility of cached query conditions by providing the actual condition text stored under the hash key. It helps users understand and debug query condition caching more effectively.

How to use it

Query the system.query_condition_cache system table to see the newly available condition field which contains the plaintext condition for each cached entry. For example: SELECT condition FROM system.query_condition_cache.