datafusion
datafusion copied to clipboard
CLI unable to execute queries with range(..) function
Describe the bug
Noticed when attempting to reproduce #9755 the initial query in that issue does not work when run against current main branch:
❯ docker build -f datafusion-cli/Dockerfile . --tag datafusion-cli
...
❯ docker run -it -v /tmp:/data datafusion-cli
DataFusion CLI v37.1.0
> CREATE
OR REPLACE TABLE pricing AS
SELECT
t,
RANDOM() as v
FROM
range(
'2022-01-01' :: TIMESTAMP,
'2023-01-01' :: TIMESTAMP,
INTERVAL 1 DAY
) ts(t);
Error during planning: table function 'range' not found
To Reproduce
Build and start CLI, run query.
Expected behavior
Query should succeed.
Additional context
No response
I think it is a related issue with https://github.com/apache/datafusion/issues/10069#issue-2241483049 and if it is necessary to register range as a default table function, I would like to do that