# orphanRemoval vs cascade = REMOVE
# Hibernate ORM 8.0.0.CR1, H2, JDK 25

== Trigger 1: child removed from the parent's collection, parent kept
-- Basket (cascade = {PERSIST, REMOVE}, no orphanRemoval): items.remove(0); flush()
   sql> select b1_0.id from Basket b1_0 where b1_0.id=?
   sql> select i1_0.basket_id,i1_0.id,i1_0.name from BasketItem i1_0 where i1_0.basket_id=?
raw rows: BasketItem=2  (still 2: nothing was deleted)
-- Invoice (cascade = ALL, orphanRemoval = true): lines.remove(0); flush()
   sql> select i1_0.id,i1_0.number from Invoice i1_0 where i1_0.id=?
   sql> select l1_0.invoice_id,l1_0.id,l1_0.description from InvoiceLine l1_0 where l1_0.invoice_id=?
   sql> delete from InvoiceLine where id=?
raw rows: InvoiceLine=1  (now 1: the orphan was deleted)

== Trigger 2: the parent itself is removed
Folder maps cascade = PERSIST and orphanRemoval = true, and has no REMOVE at all
-- remove(folder); flush()
   sql> select f1_0.id from Folder f1_0 where f1_0.id=?
   sql> select d1_0.folder_id,d1_0.id,d1_0.title from Doc d1_0 where d1_0.folder_id=?
   sql> delete from Doc where id=?
   sql> delete from Folder where id=?
raw rows: doc=0  (0: orphanRemoval alone also deletes children when the parent goes)
-- Basket (REMOVE, no orphanRemoval): remove(basket); flush()
   sql> select b1_0.id from Basket b1_0 where b1_0.id=?
   sql> select i1_0.basket_id,i1_0.id,i1_0.name from BasketItem i1_0 where i1_0.basket_id=?
   sql> delete from BasketItem where id=?
   sql> delete from Basket where id=?
raw rows: BasketItem=0  basket=0
