1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
|
# name: test/sql/function/list/aggregates/bool_and_or.test
# description: Test the list_bool_and, list_bool_or aggregate functions
# group: [aggregates]
# incorrect usage
statement error
select list_bool_or()
----
statement error
select list_bool_and()
----
# list of booleans
statement ok
CREATE TABLE bools (l BOOLEAN[]);
statement ok
INSERT INTO bools SELECT LIST(True) FROM range(100) tbl(i);
statement ok
INSERT INTO bools SELECT LIST(False) FROM range(100) tbl(i);
statement ok
INSERT INTO bools VALUES ([True, False]);
statement ok
INSERT INTO bools VALUES ([]), ([NULL]), (NULL), ([NULL, True, False, NULL]);
query I
SELECT list_bool_or(l) FROM bools;
----
1
0
1
NULL
NULL
NULL
1
query I
SELECT list_bool_and(l) FROM bools;
----
1
0
0
NULL
NULL
NULL
0
|
