|
| Description: |
{{FarmTools.DefaultLanguageUpdater}} compares the translation flag of the pages, which is an integer, with a string:
{noformat} doc.translation='0' {noformat}
Since Hibernate 6, HQL checks the types of both sides of a comparison when the query is parsed, and rejects incompatible ones ({{SemanticException: Cannot compare left expression of type ... with right expression of type ...}}). XWiki is moving to Hibernate 7 (XWIKI-19708), where these queries will fail on every database. With Hibernate 5 the literal is copied as is in the SQL, so the queries rely on the database converting it implicitly, which not all databases do.
Compare it with a number instead ({{doc.translation = 0}}). This works with all the databases and all the Hibernate versions.
PS: This post was co-written with Claude Code. |
|