v.24.10Improvement

Add Diagnostic Info for Higher-Order Array Functions

Add diagnostic info about higher-order array functions if lambda result type is unexpected. #70093 (ttanay).
Adds diagnostic information for higher-order array functions when the lambda result type is unexpected.

Why it matters

This feature helps users diagnose and understand errors related to the result type mismatches in lambda expressions used within higher-order array functions, improving debugging and usability.

How to use it

When using higher-order array functions with lambda expressions, if the lambda returns an unexpected type, ClickHouse will now provide detailed diagnostic messages to help identify and resolve the issue.