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

JPQL Query builder doesnt support exists #703

Open

snimavat opened this issue Jul 17, 2023 · 0 comments

Assignees

Contributor

snimavat commented Jul 17, 2023 •

edited

Loading

Throws error

 Queries of type Exists are not supported by this implementation

at app//gorm.tools.mango.jpql.JpqlQueryBuilder.buildWhereClauseForCriterion(JpqlQueryBuilder.groovy:782)
	at app//gorm.tools.mango.jpql.JpqlQueryBuilder.buildWhereClause(JpqlQueryBuilder.groovy:686)
	at app//gorm.tools.mango.jpql.JpqlQueryBuilder.buildUpdate(JpqlQueryBuilder.groovy:141)

Was trying to use JPQL builder for an update statement
Because grails criteria.updateAll doesnt support exists or joins.

this forces us to always use either HQL or sql if we want to run an update statement that has join/exists

The text was updated successfully, but these errors were encountered:

snimavat assigned basejump and snimavat

snimavat added a commit that referenced this issue


          #703 add test for jpql update with exists

cf1c3b8

snimavat mentioned this issue

#703 add test for jpql update with exists #704

Draft

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment