v.1.1.54388Improvement

Allow Matching Tuple Types in SQL Expressions

Official CH changelog text
Expressions like tuple IN (SELECT tuple) are allowed if the tuple types match.
Support for expressions where a tuple is compared using the IN operator against a subquery returning tuples, provided the tuple types match.

Why it matters

This feature allows users to perform tuple membership checks directly in queries, enabling more complex and expressive filtering conditions when tuples are involved. It solves the previous limitation of not supporting tuple IN (SELECT tuple) style expressions, enhancing query flexibility and correctness.

How to use it

Use the IN operator with tuples in your SQL query by ensuring the tuple and the subquery's tuple types match, for example:

SELECT * FROM table WHERE (col1, col2) IN (SELECT col1, col2 FROM other_table)
PreviousNext