Implementation of Short Circuit Function Evaluation with New Configuration Setting

Why it matters

This feature improves query performance and efficiency by avoiding unnecessary computation in function evaluation. It solves the problem of evaluating all function arguments even when the result could be determined early (e.g., logical AND/OR functions), reducing CPU usage and speeding up query execution.

How to use it

Enable short circuit function evaluation by setting the short_circuit_function_evaluation setting to true. This setting can be applied in the user profile, session, or query level to control behavior.