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


1
2
3
4
5
6
7
8
9
10
11

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


$f = ($x) -> {
    return $x * 2;
};

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