aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/expr/opt_try_member.sql
blob: 1be2db24013ef5068dbf2109e5bf06e896c905ff (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
/* postgres can not */
/* kikimr can not */
/* syntax version 1 */
select 
TryMember(Just(<|x:1|>),"x",0),
TryMember(Just(<|x:1|>),"y",0),
TryMember(Just(<|x:Just(1)|>),"x",Just(0)),
TryMember(Just(<|x:Just(1)|>),"y",Just(0)),
TryMember(Just(<|x:Nothing(Int32?)|>),"x",Just(0)),
TryMember(Just(<|x:Nothing(Int32?)|>),"y",Just(0)),

TryMember(Just(<|x:1|>),"x",null),
TryMember(Just(<|x:1|>),"y",null),
TryMember(Just(<|x:Just(1)|>),"x",null),
TryMember(Just(<|x:Just(1)|>),"y",null),
TryMember(Just(<|x:Nothing(Int32?)|>),"x",null),
TryMember(Just(<|x:Nothing(Int32?)|>),"y",null),

TryMember(Nothing(Struct<x:Int32>?),"x",0),
TryMember(Nothing(Struct<x:Int32>?),"x",null),

TryMember(Nothing(Struct<x:Int32?>?),"x",Just(0)),
TryMember(Nothing(Struct<x:Int32?>?),"x",null);