HQL Delete query with join translated to invalid SQL

Description

When a JPAQL / HQL delete query is defined using a join as below, the generated SQL is invalid though a select query with the same structure works.

The failure reported is

Verified in Hibernate 4 as well as the latest releases (5.2.17 / 5.3.0)

Environment

None

Assignee

Unassigned

Reporter

Stephen Fikes

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure