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


1
2
3
4
5
6
7
8
9

$x = (SELECT * FROM (VALUES (1)) AS x(a));
$y = (SELECT * FROM (VALUES (1)) AS y(b));
$z = (SELECT * FROM (VALUES (1)) AS z(c));

SELECT * FROM $x WHERE a IN (
    SELECT b FROM $y AS y JOIN $z AS z ON (y.b == z.c)
    UNION ALL
    SELECT b FROM $y AS y JOIN $z AS z ON (y.b == z.c)
);