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] |
|