-
Notifications
You must be signed in to change notification settings - Fork 6
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.
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
CREATE SEQUENCE fails with cursor description #44
Comments
The same approach to fix #40 should work here if you'd like to have a go? |
yes! I will open a PR later today. |
looking a little bit deeper it seems that sequences in general are not really working, because snowflake uses seq1.nextval but duckdb nextval(seq1). Which is also not supported currently in sqlglot. So I need another workaround for my tests anyway. |
Ah right.. so we probably also need a transformation from |
The other problem is that in the case of create sequence, sqlglot does not recognize sequence as token, and therefore also not the rest of the command like the name. |
Ah right. I've found the sqlglot folks receptive to PRs that add more precise parsing. |
I've added support for parsing |
Amazing, thanks! |
related to #40, the cursor description fails.
The text was updated successfully, but these errors were encountered: