Open
Description
Some functions like GENERATE_SERIES and DATE_TRUNC are not recognized with the first invocation with duckdb-rs. For following simple query:
SELECT
time_series as time_series
FROM
GENERATE_SERIES(
DATE_TRUNC(
'MONTH',
CAST('2012-01-01T00:00:00Z' AS TIMESTAMPTZ)
),
CAST('2024-04-30T23:59:59.999Z' AS TIMESTAMPTZ),
CAST('1 MONTH' AS INTERVAL)
) AS t(time_series)
I am getting:
Binder Error: No function matches the given name and argument types 'generate_series(TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH TIME ZONE, INTERVAL)'. You might need to add explicit type casts.
Candidate functions:
generate_series(BIGINT)
generate_series(BIGINT, BIGINT)
generate_series(BIGINT, BIGINT, BIGINT)
generate_series(TIMESTAMP, TIMESTAMP, INTERVAL)
LINE 14: GENERATE_SERIES(
^
The successive invocation works fine, and returns (showing wrapped json results here):
[
{
"time_series": "2012-01-01 00:00:00+00"
},
{
"time_series": "2012-02-01 00:00:00+00"
},
{
"time_series": "2012-03-01 00:00:00+00"
},
{
"time_series": "2012-04-01 00:00:00+00"
},
{
...
...
We are using, duckdb and duckdb-rs 1.2.2, running this on amd64
Metadata
Metadata
Assignees
Labels
No labels