# orphanRemoval and merge(): managed parent, emptied collection (reported as a 6.6 -> 7.x regression)
# Hibernate ORM 8.0.0.CR1, H2, JDK 25

== 1. managed invoice, getLines().clear(), merge(invoice), flush()
-- clear(); merge(inv); 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=0

== 2. managed invoice, clear(), add one new line, merge(invoice), flush()
-- clear(); addLine(); merge(inv); 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> insert into InvoiceLine (description,invoice_id,id) values (?,?,default)
   sql> delete from InvoiceLine where id=?
raw rows for invoice M-2 lines: [replacement]

== 3. the normal detached round trip: load, close session, remove a line, merge in a new session
-- merge(detachedInvoice); flush()
   sql> select i1_0.id,i1_0.number,l1_0.invoice_id,l1_0.id,l1_0.description from Invoice i1_0 left join InvoiceLine l1_0 on i1_0.id=l1_0.invoice_id where i1_0.id=?
   sql> delete from InvoiceLine where id=?
raw rows for invoice M-3 lines: [2]
outcomes: 1=ok 2=ok 3=ok
