Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Snowflake unsupported synatx #2264

Open
dereeno opened this issue Dec 22, 2024 · 0 comments · May be fixed by #2266
Open

Snowflake unsupported synatx #2264

dereeno opened this issue Dec 22, 2024 · 0 comments · May be fixed by #2266
Assignees
@taozhi8833998
Labels
bug Something isn't working
Milestone
5.3.6

Comments

@dereeno
Copy link

dereeno commented Dec 22, 2024

Describe the bug
The following syntax should be valid on Snowflake

Database Engine
Snowflake

To Reproduce

SELECT
  SUM(id) OVER (
    PARTITION BY
      name
    ORDER BY
      created_at ASC RANGE BETWEEN INTERVAL '9 DAYS' PRECEDING
      AND CURRENT ROW
  ) last10Dmatches
FROM
  model1

Expected behavior
Should be valid
@taozhi8833998 taozhi8833998 added the bug Something isn't working label Dec 23, 2024
@taozhi8833998 taozhi8833998 added this to the 5.3.6 milestone Dec 23, 2024
@taozhi8833998 taozhi8833998 linked a pull request Dec 23, 2024 that will close this issue
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@taozhi8833998 taozhi8833998

Labels
bug Something isn't working
Projects
None yet
Milestone
5.3.6
Development

Successfully merging a pull request may close this issue.

fix: over window frame current row in snwoflake taozhi8833998/node-sql-parser
2 participants
@dereeno @taozhi8833998