aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/expr/list_flatten.sql
blob: 4a4eda4b46e6c3c35834f84d714a566802a944f7 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
/* postgres can not */
/* syntax version 1 */
select ListFlatten(null),ListFlatten([]),
    ListFlatten(Just([])),ListFlatten(Nothing(EmptyList?)),
    ListFlatten([[],[]]),ListFlatten([null,null]),
    ListFlatten([Just([]),Just([])]),
    ListFlatten(Just([[],[]])),ListFlatten(Just([null,null])),
    ListFlatten(Just([Just([]),Just([])]));
    
select ListFlatten([[1,2],[3,4]]),
    ListFlatten([[1,2],null,[3,4]]),
    ListFlatten(Just([[1,2],[3,4]])),
    ListFlatten(Just([[1,2],null,[3,4]])),
    ListFlatten([Just([1,2]),Just([3,4])]),
    ListFlatten(Just([Just([1,2]),Just([3,4])]));