Hibernate translates JPA QL {{delete from C c where c.b.a.id = :val}} to SQL statement {{DELETE FROM C CROSS[*] JOIN B B1_ WHERE A_ID=?}}
H2 does not understand the generated SQL. Fails with {{ ``` Syntax error in SQL statement "DELETE FROM C CROSS[*] JOIN B B1_ WHERE A_ID=? "; SQL statement: delete from C cross join B b1_ where a_id=? [42000-197] }} ``` Please see test in attached project. [^mvp-h2-wrong-sql.zip] |
|