yql/essentials/tests/sql/suites/in/YQL-18950.yql


1
2
3
4
5
6
7
8

PRAGMA AnsiInForEmptyOrNullableItemsCollections;

$list = AsList(
    AsTuple(Just("aa"), Just("aaa")),
    AsTuple(Just("bb"), Just("bbb")),
);

SELECT ListMap($list, ($item) -> { RETURN 'bb' IN $item; });