ydb/yql/essentials/tests/sql/suites/expr/iterable.sql

/* postgres can not */
/* syntax version 1 */
$a = Yql::ToList(()->(Yql::Iterator([1,2,3])));
select ListExtend($a, $a), ListHasItems($a), ListLength($a);

$b = Yql::ToList(()->(Yql::EmptyIterator(Stream<Int32>)));
select ListExtend($b, $b), ListHasItems($b), ListLength($b);

$c = Yql::ToList(()->(Yql::EmptyIterator(Stream<Int32>)));
select ListExtend($b, $b), ListLength($c), ListHasItems($c);

select ListMap(ListFromRange(1,4), ($x)->{
    $y = Yql::ToList(()->(Yql::Iterator([1,2,$x])));
    return ListExtend($y, $y);
    });