v.21.9Improvement

Remove GLOBAL Keyword for IN with Scalar Functions

Official CH changelog text
Remove GLOBAL keyword for IN when scalar function is passed. In previous versions, if user specified GLOBAL IN f(x) exception was thrown. #26217 (Amos Bird).
Removed the support for the GLOBAL keyword when used with IN and a scalar function as the argument, preventing exceptions.

Why it matters

Previously, using GLOBAL IN f(x) where f(x) is a scalar function caused an exception. This change improves query stability and correctness by disallowing an invalid syntax that caused errors.

How to use it

Avoid using the GLOBAL keyword with IN when the right-hand side is a scalar function. Instead, just use IN f(x) without the GLOBAL modifier.

Related resources

PreviousNext