# @OneToOne: an owned profile cascades, a shared address does not
# Hibernate ORM 7.4.15.Final, H2, JDK 25

== Persisting a person with a new profile and a new, unsaved address
-- persist(person); flush()
   sql> insert into Profile (bio,id) values (?,default)
   sql> insert into Person (billingAddress_id,name,profile_id,id) values (?,?,?,default)
   threw: java.lang.IllegalStateException <- org.hibernate.TransientPropertyValueException
   cause: Persistent instance of 'com.ankurm.cascade.Person' references an unsaved transient instance of 'com.ankurm.cascade.Address' (persist the transient instance before flushing) [com.ankurm.cascade.Person.billingAddress -> com.ankurm.cascade.Address]
raw rows after rollback: Person=0 Profile=0

== Same, with the shared address persisted first
raw rows: Person=1 Profile=1 Address=1
-- setProfile(null); flush()  (orphanRemoval)
   sql> select p1_0.id,ba1_0.id,ba1_0.line1,p1_0.name,p2_0.id,p2_0.bio from Person p1_0 left join Address ba1_0 on ba1_0.id=p1_0.billingAddress_id left join Profile p2_0 on p2_0.id=p1_0.profile_id where p1_0.id=?
   sql> update Person set billingAddress_id=?,name=?,profile_id=? where id=?
   sql> delete from Profile where id=?
raw rows: Profile=0
-- remove(person); flush()
   sql> select p1_0.id,ba1_0.id,ba1_0.line1,p1_0.name,p2_0.id,p2_0.bio from Person p1_0 left join Address ba1_0 on ba1_0.id=p1_0.billingAddress_id left join Profile p2_0 on p2_0.id=p1_0.profile_id where p1_0.id=?
   sql> delete from Person where id=?
   sql> delete from Profile where id=?
raw rows: Person=0 Profile=0 Address=1  (the address survives)
