[hibernate-issues] [JIRA] (HHH-17031) HQL - DELETE does not delete child entity.

Satish ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5f990cf... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNjA4MjhhYzYz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-17031?atlOrigin=eyJpIjoiNjA4Mj... ) HHH-17031 ( https://hibernate.atlassian.net/browse/HHH-17031?atlOrigin=eyJpIjoiNjA4Mj... ) HQL - DELETE does not delete child entity. ( https://hibernate.atlassian.net/browse/HHH-17031?atlOrigin=eyJpIjoiNjA4Mj... ) Change By: Satish ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5f990cf... ) {noformat}When using HQL to DELETE a parent entity, the delete is not cascaded to child entity. Here is a snippet of code that has the issues, detailed test case is below. transaction.begin(); // Use HQL to delete the parent. With CASCADE.ALL, // the child should be deleted. --- DOES NOT DELETE Query query = em.createQuery("DELETE FROM ParentEntity WHERE id = :parentId"); query.setParameter("parentId", parentId); query.executeUpdate(); transaction.commit(); But this piece of code cascades and deletes the child entity. // Delete using EM ----  WORKS FINE! int parentId = parentEntity1.getId(); transaction.begin(); ParentEntity retrievedParent = em.find(ParentEntity.class, parentId); em.remove(retrievedParent); transaction.commit(); -- Database tables needed for the test case create table TEST.TEST_PARENT_TABLE ( ID                  INTEGER not null primary key, NAME                VARCHAR(256) ); create table TEST.TEST_CHILD_TABLE ( ID                  INTEGER not null primary key, NAME                VARCHAR(256) );{noformat} ----ParentEntity.java -------- {noformat}package com.example; import jakarta.persistence.*; import java.io.Serializable; import org.hibernate.annotations.NotFound; import org.hibernate.annotations.NotFoundAction; @Entity @Table(name = "TEST_PARENT_TABLE", schema = "TEST") public class ParentEntity implements Serializable { private Integer id; private String name; private ChildEntity childEntity; @Id @Column(name = "ID") public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } @Column(name = "NAME") public String getName() { return name; } public void setName(String name) { this.name = name; } @OneToOne(cascade = CascadeType.ALL, fetch = FetchType.EAGER, orphanRemoval = true) @PrimaryKeyJoinColumn(name = "ID") @NotFound(action = NotFoundAction.IGNORE) public ChildEntity getChildEntity() { return childEntity; } public void setChildEntity(ChildEntity childEntity) { this.childEntity = childEntity; }{noformat} --ChildEntity.java {noformat}package com.example; import jakarta.persistence.Column; import jakarta.persistence.Entity; import jakarta.persistence.Id; import jakarta.persistence.Table; import java.io.Serializable; @Entity @Table(name = "TEST_CHILD_TABLE", schema = "TEST") public class ChildEntity implements Serializable { private Integer id; private String name; @Id @Column(name = "ID") public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } @Column(name = "NAME") public String getName() { return name; } public void setName(String name) { this.name = name; } } {noformat} ( https://hibernate.atlassian.net/browse/HHH-17031#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-17031#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#100233- sha1:3ea1a2a )