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
|
# name: test/sql/function/list/aggregates/kurtosis.test
# description: Test the list_kurtosis aggregate function
# group: [aggregates]
query I
select list_kurtosis([1])
----
NULL
query I
select list_kurtosis([0, 0, 0, 0, 0, 0])
----
NULL
# out of range
statement error
select list_kurtosis([2e304, 2e305, 2e306, 2e307])
----
<REGEX>:.*Out of Range Error.*out of range.*
statement ok
create table aggr(k int[]);
statement ok
insert into aggr values ([1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2]),
([10, 10, 10, 10, 20, 20, 25, 30, 30, 30, 30]),
([NULL, 11, 15, 18, 22, 25, NULL, 35, 40, 50, 51]),
(NULL), ([]), ([NULL]);
query I
select list_kurtosis(k) from aggr;
----
11.000000
-1.961428
-1.445120
NULL
NULL
NULL
query I
select list_kurtosis_pop(k) from aggr;
----
6.100000
-1.676857
-1.358688
NULL
NULL
NULL
# incorrect usage
statement error
select list_kurtosis()
----
<REGEX>:.*Binder Error.*does not support the supplied arguments.*
|
