Error when trying to perform a single field update action using JPA-QL

[ilmoralito]

I'm trying to perform an update action in a single field using gorm data services through grails.gorm.services.Query. In the documentation I found an example very similar to my case of use

@Query("update ${Book book} set ${book.title} = $newTitle where book.title = $oldTitle")
Number updateTitle(String newTitle, String oldTitle)

The code that I try is the following:

@Query("update ${Activity activity} set ${activity.state} = $state where activity.id = $id")
Activity updateState(final String state, final Serializable id)

I am getting a query exception org.grails.orm.hibernate.exceptions.GrailsQueryException with the following caused by message

Invalid query [UPDATE anotherdemo.Activity as activity SET activity.state = :p0 WHERE activity.id = :p1] for domain class [anotherdemo.Activity]

Please visit this link to a github repository with an example app that reproduces the issue

Environment Information

• Operating System: Ubuntu 16.04
• Grails Version: 3.3.0.M2
• JDK Version: Using java version 8u121

Thanks for your time

[jeffscottbrown]

The return type appears to be an issue. The change I made at jeffscottbrown/demo-app-for-updating-single-field@9431502 works.

This looks like a problem in the Data Service compiler.

[graemerocher]

Not really a problem in the compiler, the query doesn't return anything, so how does one obtain a reference to the Activity instance?

[graemerocher]

Granted I think this query should fail to compile