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
|
# name: test/sql/table_function/range_non_foldable.test
# description: Issue #5546: non-foldable constant parameters to table function
# group: [table_function]
require no_extension_autoloading "FIXME: Unimplemented type for cast (TIMESTAMP WITH TIME ZONE -> DATE)"
require icu
statement ok
PRAGMA enable_verification
query I
SELECT COUNT(*)
FROM range(
current_date,
current_date + interval '7' days,
interval '1 day'
)
----
7
statement ok
SELECT to_timestamp(range) as entry
FROM range(
epoch(date_trunc('month', current_date))::BIGINT,
epoch(date_trunc('month', current_date) + interval '1 month' - interval '1 day')::BIGINT,
epoch(interval '1 day')::BIGINT
)
statement ok
SELECT to_timestamp(range) as entry
FROM range(
epoch(date_trunc('month', current_date))::BIGINT,
epoch(date_trunc('month', current_date) + interval '1 month' - interval '1 day')::BIGINT,
epoch(interval '1 day')::BIGINT
)
|
