Skip to content

SQL queries containing unsupported 'FETCH NEXT' keyword execute successfully (SQLStorm) #17716

@2010YOUY01

Description

@2010YOUY01

Describe the bug

datafusion-cli is compiled from the latest main commit 1629420

> SELECT * FROM (VALUES (1), (2), (3)) AS t(x) FETCH NEXT 1 ROWS ONLY;
+---+
| x |
+---+
| 1 |
| 2 |
| 3 |
+---+
3 row(s) fetched.
Elapsed 0.040 seconds.

FETCH NEXT is not supported, it should return a planning error.

To Reproduce

No response

Expected behavior

No response

Additional context

Found by SQLStorm #17698

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions