v.23.9Improvement

More Precise Integer Type Inference Fix

More precise integer type inference, fix #51236. #53003 (Chen768959).
Improved precision in integer type inference during query analysis to prevent incorrect type assignments.

Why it matters

This feature addresses the issue where integer types could be inferred inaccurately, leading to potential errors or inefficiencies in query processing. By refining the integer type inference mechanism, ClickHouse ensures that integer operations and expressions use the most appropriate and precise data types, enhancing query reliability and performance.

How to use it

This improvement is applied automatically in ClickHouse starting from the version including this fix. No additional configuration or user action is required to benefit from the more precise integer type inference.