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


1
2
3
4
5
6
7
8
9
10
11

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


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

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