Recent H2-Dtabase CVE’s forced our team to migrate from H2 1.X.X to latest. Here a snippet
Causing
After some debugs, we noticed that the hsql is translated to sql with a syntax not supported anymore by the newest H2 version. The “in” statement is surrounded by double parentheses
When executing manually the generated SQL in our H2 database, it does work when replacing the double parentheses with single parenthesis, like the following
|