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


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

$data = [<|optionalValue:  Just(Just(4)), missingValue: -1|>,
         <|optionalValue:  Just(Nothing(int32?)), missingValue: -2|>,
         <|optionalValue: Just(Just(404)), missingValue: -3|>,
         <|optionalValue: Nothing(int32??), missingValue: -4|>,];


$g = ($y) -> {
    return $y * 4;
};

$f = ($x) -> {
    return YQL::IfPresent($x, $g, 55);
};

SELECT YQL::IfPresent(optionalValue, $f, missingValue) FROM as_table($data);