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


1
2
3
4
5
6
7
8
9
10
11
12

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

PRAGMA AnsiInForEmptyOrNullableItemsCollections;

SELECT
    1         IN {2, 3, null},          -- Nothing<Bool?>
    2         IN {2, 3, null},          -- true?
    (1, 2)    IN {(1, null), (2, 1)},   -- Nothing<Bool?>
    (1, 2)    IN {(1, null), (1, 2)},   -- true?
;