list_shuffle.sql 720 B

123456789101112131415161718192021
  1. /* yt can not */
  2. $list = ListFromRange(1, 40);
  3. $test = ($c) -> {
  4. $shuffle = ListCollect(ListShuffle($list, $c));
  5. RETURN ListSort($shuffle) == ListSort($list);
  6. };
  7. SELECT
  8. ListShuffle(NULL ) IS NULL AS mustBeTrue1,
  9. ListShuffle(Nothing(OptionalType(ListType(DataType("Uint64"))))) IS NULL AS mustBeTrue2,
  10. ListShuffle([] ) == [] AS mustBeTrue3,
  11. ListShuffle($list, 123) == ListShuffle($list, 123) AS mustBeTrue4,
  12. $test(1) AS result1,
  13. $test(2) AS result2,
  14. $test(3) AS result3,
  15. $test(4) AS result4,
  16. ListShuffle($list , 5) AS result5,
  17. ListShuffle(Just($list), 6) AS result6;