We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
Describe the bug When trying to parse a postgresql statement with an NTILE in it we are getting the following error:
"Expected \",\", \"--\", \"/*\", \";\", \"FROM\", \"GROUP\", \"HAVING\", \"INTO\", \"LIMIT\", \"OFFSET\", \"ORDER\", \"UNION\", \"WHERE\", \"WINDOW\", [ \\t\\n\\r], or end of input but \"(\" found."
PostgreSQL description of NTILE
Database Engine PostgreSQL.
To Reproduce -the SQL that be parsed
SELECT name, amount, NTILE (3) OVER ( ORDER BY amount ) ntile, unset(_id) FROM function-test-data WHERE testId='bugfix.ntile.case1'
-the node-sql-parser version 4.6.5 -the node version v14.21.1
4.6.5
v14.21.1
Expected behavior To get back a parsed AST
Screenshots N/A
Additional context N/A
The text was updated successfully, but these errors were encountered:
taozhi8833998
Successfully merging a pull request may close this issue.
Describe the bug
When trying to parse a postgresql statement with an NTILE in it we are getting the following error:
"Expected \",\", \"--\", \"/*\", \";\", \"FROM\", \"GROUP\", \"HAVING\", \"INTO\", \"LIMIT\", \"OFFSET\", \"ORDER\", \"UNION\", \"WHERE\", \"WINDOW\", [ \\t\\n\\r], or end of input but \"(\" found."
PostgreSQL description of NTILE
Database Engine
PostgreSQL.
To Reproduce
-the SQL that be parsed
-the node-sql-parser version
4.6.5
-the node version
v14.21.1
Expected behavior
To get back a parsed AST
Screenshots
N/A
Additional context
N/A
The text was updated successfully, but these errors were encountered: