-
Notifications
You must be signed in to change notification settings - Fork 1.4k
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
BadJpqlGrammarException with the latest release when using query hints inside the query #3385
Comments
It's weird |
From the exception, I assume JSQLParser is throwing the exception. |
Adding stacktrace.
|
So things in this thread do not really line up. |
Here is a sample project to reproduce the error |
We are facing an issue with the latest version of Spring Boot 3.2.2 upgrade.
My SQL query is:
The issue we have:
Line 1:92 mismatched input 'WITH' expecting {<EOF>, ',', CROSS, EXCEPT, FULL, GROUP, INNER, INTERSECT, JOIN, LEFT, ORDER, OUTER, RIGHT, UNION, WHERE}; Bad JPQL grammar [SELECT c.key, c.code, c.description FROM TEST c WITH (FORCESEEK) WHERE EXISTS (SELECT TOP(1) 1 FROM testData td WHERE td.key=c.key) AND c.key BETWEEN :minKey AND :maxKey]
The query was working fine before the upgrade in Spring Boot 2.6.14
Thanks for any advice to fix the issue
The text was updated successfully, but these errors were encountered: