v.25.4Improvement
Add field condition to system table system
Added fieldconditionto system tablesystem.query_condition_cache. It stores the plaintext condition whose hash is used as a key in the query condition cache. #78671 (Robert Schulze).
Why it matters
This feature provides insight into the actual conditions cached in the query condition cache by exposing the plaintext expressions. It helps users understand and debug the cache contents more easily by linking the hash keys to their corresponding query conditions.How to use it
Users can query thesystem.query_condition_cache table and check the new condition field to view the plaintext conditions currently stored in the query condition cache, enabling better monitoring and troubleshooting.