BadJpqlGrammarException: no viable alternative at input

[m-ignatov]

Spring Data JPA throws BadJpqlGrammarException: Line 1:139 no viable alternative at input 'L.forceUnlockTime<:time'; Bad JPQL grammar [UPDATE Lock L SET L.isLocked = TRUE, L.forceUnlockTime = :forceUnlockTime WHERE L.isLocked = FALSE OR L.forceUnlockTime < :time]

@Query("UPDATE Lock L SET L.isLocked = TRUE, L.forceUnlockTime = :forceUnlockTime WHERE L.isLocked = FALSE OR L.forceUnlockTime < :time")
int acquireLock(@Param("forceUnlockTime") Date forceUnlockTime, @Param("time") Date time);

We are using the latest Spring Boot BOM 3.1.2 with Spring Data JPA 3.1.2.

[gregturn]

Merged to main, backported to 3.1.x.

[quaff]

I'm wondering if #3010 could resolve such problem permanently.