v.23.7Improvement

Add Missing Projection QueryAccessInfo for Optimized Query Plans

Add back missing projection QueryAccessInfo when query_plan_optimize_projection = 1. This fixes #50183 . This fixes #50093. #52327 (Amos Bird).
Restores the missing projection QueryAccessInfo when the setting query_plan_optimize_projection = 1 is enabled.

Why it matters

This feature addresses bugs where projection query access information was lost when query plan optimization for projections was enabled. Restoring this information fixes issues related to query execution and optimization, improving stability and correctness of query plans involving projections.

How to use it

Enable the feature by setting query_plan_optimize_projection = 1 in your ClickHouse configuration or session settings to benefit from optimized query plans with correct projection query access information.