yql/essentials/tests/sql/suites/in/in_with_tuple.sql


1
2
3
4
5
6
7
8
9

/* postgres can not */
SELECT *
FROM plato.Input
WHERE AsTuple(cast(key as int32) ?? 0, cast(subkey as int32) ?? 0) in (
    AsTuple(800, 1),
    AsTuple(800, 2),
    AsTuple(800, 3),
    AsTuple(800, 4),
);