aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/blocks/ifpresent_two_args.sql
blob: 77af51cdfced3517c13097a97a805ac3c4db0670 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
$data = [<|optionalValue: Just(4), optionalValue2: Just(404), missingValue: -1|>,
         <|optionalValue: Nothing(int32?), optionalValue2: Just(404), missingValue: -2|>,
         <|optionalValue: Just(404), optionalValue2: Just(404), missingValue: -3|>,
         <|optionalValue: Nothing(int32?), optionalValue2: Nothing(int32?), missingValue: -4|>,];

$g = ($x, $g) -> {
    return $x * $g;
};

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