summaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/blocks/and_opt_scalar.yql
blob: 1c11b2e9b523aa1a29e6fe277633d028f69c9ec2 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
$data = [
    <|x:false,y:false|>,
    <|x:false,y:true|>,
    <|x:false,y:null|>,
    <|x:true,y:false|>,
    <|x:true,y:true|>,
    <|x:true,y:null|>,
    <|x:null,y:false|>,
    <|x:null,y:true|>,
    <|x:null,y:null|>,
];

select x,y,Opaque(false) and y,Opaque(true) and y,Opaque(Nothing(bool?)) and y from as_table($data);
select x,y,x and Opaque(false),x and Opaque(true),x and Opaque(Nothing(bool?)) from as_table($data);