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


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

/* syntax version 1 */
/* postgres can not */

PRAGMA DisableAnsiInForEmptyOrNullableItemsCollections;

SELECT
    null      IN EmptyList(),                    -- Nothing<Bool?>
    null      IN EmptyDict(),                    -- Nothing<Bool?>
    null      IN (),                             -- Nothing<Bool?>
    1         IN EmptyList(),                    -- false
    1         IN EmptyDict(),                    -- false
    1         IN (),                             -- false
    null      IN Nothing(EmptyList?),            -- Nothing<Bool?>
    null      IN Nothing(EmptyDict?),            -- Nothing<Bool?>
    null      IN Nothing(ParseType("Tuple<>?")), -- Nothing<Bool?>
;