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
|
# name: test/sql/function/list/list_reverse.test_slow
# group: [list]
statement ok
PRAGMA enable_verification
statement ok
CREATE TABLE all_types AS SELECT * FROM test_all_types();
foreach colname bool tinyint smallint int bigint hugeint utinyint usmallint uint ubigint date time timestamp timestamp_s timestamp_ms timestamp_ns time_tz timestamp_tz float double dec_4_1 dec_9_4 dec_18_6 dec38_10 uuid interval varchar blob small_enum medium_enum large_enum int_array double_array date_array timestamp_array timestamptz_array varchar_array nested_int_array struct struct_of_arrays array_of_structs map
statement ok
select list_reverse(["${colname}"]) FROM all_types;
endloop
statement ok
create table tbl as select range(5000) as list;
query I nosort reversered list
select list_sort(range(5000), 'desc');
----
query I nosort reversered list
select list_reverse(list) from tbl;
----
# test incorrect parameter type
foreach type boolean varchar tinyint smallint integer bigint hugeint utinyint usmallint uinteger ubigint float double decimal(4,1) decimal(9,4) decimal(18,6) decimal(38,10) date time timestamp timestamp_s timestamp_ms timestamp_ns timetz timestamptz interval blob
statement error
SELECT list_reverse(NULL::${type})
----
endloop
|
