This should be the same as [TEIID-3549] Join conditions with OR generate a wrong JDBC query - JBoss Issue Tracker However the HSQL translator is not marked as requiring the parens. Can you open an issue for that?
Right, thanks, Steve. H2 and HSQL share their origins and probably still a lot of their code.
Thanks Gabriel. The fix will be in 8.13.4 and the next 9.0.0 pre-release.