# @OnDelete(CASCADE): the database deletes the children, Hibernate does not know
# Hibernate ORM 7.4.15.Final, H2, JDK 25
LedgerEntry foreign key: [FKJW461MHMPCBIN06DVK8AU5D6F | CASCADE]
VaultEntry  foreign key: [FK84JU8V00N04VVRD9SKS3NCU3I | CASCADE]

== 1. Ledger: @OnDelete only, children never loaded
-- remove(find(Ledger)); flush()
   sql> select l1_0.id from Ledger l1_0 where l1_0.id=?
   sql> delete from Ledger where id=?
raw rows: Ledger=0 LedgerEntry=0

== 2. Ledger: @OnDelete only, but the entries are already loaded in the session
-- find(Ledger); entries.size(); remove(ledger); flush()
   sql> select l1_0.id from Ledger l1_0 where l1_0.id=?
   sql> select e1_0.ledger_id,e1_0.id,e1_0.memo from LedgerEntry e1_0 where e1_0.ledger_id=?
   threw: java.lang.IllegalStateException <- org.hibernate.TransientPropertyValueException
   cause: Persistent instance of 'com.ankurm.cascade.LedgerEntry' references an unsaved transient instance of 'com.ankurm.cascade.Ledger' (persist the transient instance before flushing) [com.ankurm.cascade.LedgerEntry.ledger -> com.ankurm.cascade.Ledger]

== 3. Vault: cascade = ALL plus @OnDelete, entries loaded
-- find(Vault); remove(vault); flush()
   sql> delete from Vault where id=?
raw rows after commit: Vault=0 VaultEntry=0
same session, contains(firstEntry) after commit: false
same session, find(VaultEntry first): null

== 4. A cascade that only exists in the schema: the mapping (ProjectGood -> AppUser) says nothing about it
ProjectGood foreign key now: [FK_PROJECT_OWNER | CASCADE]
-- native: delete from AppUser where id = ?
   sql> delete from AppUser where id = ?
raw rows: AppUser(id)=0 ProjectGood(id)=0
same session, find(ProjectGood) -> still returns the deleted project
SQL issued by that find: 0
same session, contains(project): true
after session.clear(), find(ProjectGood) -> null
