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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
|
# name: test/sql/function/list/aggregates/null_or_empty.test
# description: Test the list_aggr function for NULL, [NULL], [] and zero rows
# group: [aggregates]
# NULL list
foreach func_name avg favg approx_count_distinct bit_and bit_or bit_xor bool_or bool_and count entropy first arbitrary histogram kurtosis last mad max median min mode array_agg list product sem skewness string_agg group_concat sum fsum sumKahan kahan_sum var_samp var_pop stddev stddev_pop variance stddev_samp
query I
SELECT list_aggr(NULL, '${func_name}')
----
NULL
endloop
# [NULL] list with NULL result
foreach func_name avg favg bit_and bit_or bit_xor bool_or bool_and first arbitrary histogram kurtosis last mad max median min mode product sem string_agg group_concat sum fsum sumKahan kahan_sum var_samp var_pop stddev stddev_pop variance stddev_samp
query I
SELECT list_aggr([NULL], '${func_name}')
----
NULL
endloop
# [NULL] list with 0 result
foreach func_name approx_count_distinct count entropy
query I
SELECT list_aggr([NULL], '${func_name}')
----
0
endloop
# [NULL] list with [NULL] result
foreach func_name array_agg list
query I
SELECT list_aggr([NULL], '${func_name}')
----
[NULL]
endloop
# empty list with NULL result
foreach func_name avg favg bit_and bit_or bit_xor bool_or bool_and first arbitrary histogram kurtosis last mad max median min mode array_agg list product sem skewness string_agg group_concat sum fsum sumKahan kahan_sum var_samp var_pop stddev stddev_pop variance stddev_samp
query I
SELECT list_aggr([], '${func_name}')
----
NULL
endloop
# select * from NULL list
foreach func_name avg favg approx_count_distinct bit_and bit_or bit_xor bool_or bool_and count entropy first arbitrary histogram kurtosis last mad max median min mode array_agg list product sem skewness string_agg group_concat sum fsum sumKahan kahan_sum var_samp var_pop stddev stddev_pop variance stddev_samp
query I
select * from (SELECT list_aggr(NULL, '${func_name}'))
----
NULL
endloop
# empty list with 0 result
foreach func_name approx_count_distinct count entropy
query I
SELECT list_aggr([], '${func_name}')
----
0
endloop
# zero rows
foreach func_name approx_count_distinct avg favg bit_and bit_or bit_xor bool_and bool_or count entropy first arbitrary histogram kurtosis last mad max median min mode array_agg list product sem skewness string_agg group_concat sum fsum sumKahan kahan_sum var_samp var_pop stddev stddev_pop variance stddev_samp
query I
SELECT list_aggr([], '${func_name}') WHERE 1 = 0
----
endloop
|
