Skip to content

CLI unable to execute queries with range(..) function #10177

Closed

Description

@Omega359

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

Activity

  1. Lordworms commented on Apr 23, 2024

    @Lordworms
    Contributor

    I think it is a related issue with #10069 (comment)
    and if it is necessary to register range as a default table function, I would like to do that

  2. Omega359 commented on Dec 31, 2025

    @Omega359
    ContributorAuthor

    This issue is now fixed.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions