[hibernate-issues] [Hibernate-JIRA] Created: (HHH-7314) DELETE Query generating invalid SQL for PostgreSQL databases.

DELETE Query generating invalid SQL for PostgreSQL databases. ------------------------------------------------------------- Key: HHH-7314 URL: https://hibernate.onjira.com/browse/HHH-7314 Project: Hibernate ORM Issue Type: Bug Components: core, entity-manager Affects Versions: 4.1.3, 4.1.2 Environment: Hibernate 4.1.2, 4.1.3, PostgreSQL 9.1 (should effect all releases from 8.1 ~ current) Reporter: Bryan Varner Using a JPA Delete query with conditions requiring a join through Hibernate entity-manager generates invalid SQL for PostgreSQL. PostgreSQL cannot use CROSS JOIN in the FROM clause of a DELETE query. For example: JPQL Query {code} DELETE FROM Foo f WHERE f.bar.key = :key AND f.anotherprop = :anotherval {code} Generates an (invalid) SQL query like: {code} delete from schema.Foo cross join schema.Bar bar1_ where key=$1 and anotherprop=$2 {code} For PostgreSQL I believe this needs to look like: {code} delete from schema.Foo using schema.Bar bar1_ where key=$1 and anotherprop=$2 {code} PostgreSQL documentation on the DELETE syntax: http://www.postgresql.org/docs/8.1/static/sql-delete.html http://www.postgresql.org/docs/9.1/static/sql-delete.html -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira