v.23.5Improvement

Add support for single-element tuples in IN operator

Add support for (an unusual) case where the arguments in the IN operator are single-element tuples. #49844 (MikhailBurdukov).
Added support for the case where the arguments in the IN operator are single-element tuples.

Why it matters

This feature addresses an unusual syntax scenario in ClickHouse where the IN operator is used with single-element tuples as arguments. It improves query flexibility and correctness by allowing such expressions to work as expected without errors or unexpected behavior.

How to use it

Users can now write queries using the IN operator with single-element tuples directly in their SQL statements without needing any special configuration or workarounds.