[hibernate-issues] [JIRA] (HHH-16615) SQL query accesses non-existing alias in update/delete

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16615 ( https://hibernate.atlassian.net/browse/HHH-16615?atlOrigin=eyJpIjoiYTQ2Mm... ) Re: SQL query accesses non-existing alias in update/delete ( https://hibernate.atlassian.net/browse/HHH-16615?atlOrigin=eyJpIjoiYTQ2Mm... ) Hello Steffen Schäfer ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5f1ef7e... ) , the unexpected alias is used because your query would need an implicit join ( PrivateSubData with PrivateData ) to use the person_id column. Joins are currently not supported for mutation queries in Hibernate 6. I also tested your example with Hibernate 5.6 since you reported it was working but it did not work for me. One way to work around this would be using a subquery, something like: update PrivateSubData psd set psd.dataName = '...' where psd. data.id in ( select data.id from PrivateData data where data.person.id = ?1) ( https://hibernate.atlassian.net/browse/HHH-16615#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16615#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100225- sha1:d82e018 )