aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/expr/list_shuffle.sql
blob: 8051e76ad3c7c9ea2bd25d6fcb4c1d2385096338 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
/* yt can not */
$list = ListFromRange(1, 40);
$test = ($c) -> { 
    $shuffle = ListCollect(ListShuffle($list, $c));
    RETURN ListSort($shuffle) == ListSort($list);
};

SELECT
    ListShuffle(NULL                                               ) IS NULL AS mustBeTrue1,
    ListShuffle(Nothing(OptionalType(ListType(DataType("Uint64"))))) IS NULL AS mustBeTrue2,
    ListShuffle([]                                                 ) == []   AS mustBeTrue3,

    ListShuffle($list, 123) == ListShuffle($list, 123) AS mustBeTrue4,

    $test(1) AS result1,
    $test(2) AS result2,
    $test(3) AS result3,
    $test(4) AS result4,

    ListShuffle($list      , 5) AS result5,
    ListShuffle(Just($list), 6) AS result6;