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
|
# name: test/sql/function/list/aggregates/uhugeint.test
# description: Test uhugeint aggregates
# group: [aggregates]
statement ok
CREATE TABLE uhugeints(h UHUGEINT[])
statement ok
INSERT INTO uhugeints VALUES ([NULL, 1, 2]), (NULL), ([]), ([NULL]), ([1, 2, 3])
query III
SELECT list_first(h), list_last(h), list_sum(h) FROM uhugeints
----
NULL 2 3
NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
1 3 6
statement ok
DELETE FROM uhugeints
statement ok
INSERT INTO uhugeints VALUES ([42.0, 1267650600228229401496703205376, 0, '1']);
query IIIII
SELECT list_min(h), list_max(h), list_sum(h), list_first(h), list_last(h) FROM uhugeints;
----
0 1267650600228229401496703205376 1267650160380990427257727966431 42 1
|
