yql/essentials/tests/sql/suites/blocks/coalesce.yql


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

$data1 = [
    <|x:nothing(int32?),y:10|>,
    <|x:just(1),y:10|>,
];

$data2 = [
    <|x:nothing(int32?),y:just(10)|>,
    <|x:just(1),y:just(10)|>,
    <|x:just(1),y:nothing(int32?)|>,
];

select x ?? y from as_table($data1);

select x ?? y from as_table($data2);