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.

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

Trino sql parser no longer reports * errors correctly #2119

Open
npmccauslin opened this issue Sep 16, 2024 · 0 comments
Open

Trino sql parser no longer reports * errors correctly #2119

npmccauslin opened this issue Sep 16, 2024 · 0 comments
Assignees

Comments

@npmccauslin
Copy link

Describe the bug
At some point, the parser used to show an error on the * for syntax in this query:

SELECT *
FROM someTable
WHERE u BETWEEN * * * * * * * * * t('today')
LIMIT 10

It now instead reports t as the error.

Database Engine
which database engine does your SQL running on? such as MySQL, PostgreSQL.

Trino

To Reproduce
-the SQL that be parsed
-the node-sql-parser version
-the node version

Using

SELECT *
FROM someTable
WHERE u BETWEEN * * * * * * * * * t('today')
LIMIT 10

Node version: v18.20.4
node-sql-version: v5.3.2

Notice the error is not reported on the * but rather the t.

Expected behavior
A clear and concise description of what you expected to happen.

Syntax error on the first *.

Screenshots
If applicable, add screenshots to help explain your problem.

Additional context
Add any other context about the problem here.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants