# @ManyToOne with cascade = {PERSIST, MERGE}: what it is for, and what it cannot do
# Hibernate ORM 7.4.15.Final, H2, JDK 25

== New parent created together with its first child
-- persist(new Ticket(.., new Agent())); flush()
   sql> insert into Agent (name,id) values (?,default)
   sql> insert into Ticket (agent_id,subject,id) values (?,?,default)
raw rows: Ticket=1 Agent=1

== Parent already exists (a detached Agent): persist vs merge
-- persist(new Ticket(.., detachedAgent)); flush()
   (no SQL)
   threw: jakarta.persistence.EntityExistsException <- org.hibernate.PersistentObjectException
   cause: Detached entity passed to persist: com.ankurm.cascade.Agent
-- merge(new Ticket(.., detachedAgent)); flush()
   sql> select a1_0.id,a1_0.name from Agent a1_0 where a1_0.id=?
   sql> insert into Ticket (agent_id,subject,id) values (?,?,default)
raw rows: Ticket=2 Agent=2

== Removing a ticket never touches its agent
-- remove(ticket); flush()
   sql> select t1_0.id,a1_0.id,a1_0.name,t1_0.subject from Ticket t1_0 left join Agent a1_0 on a1_0.id=t1_0.agent_id where t1_0.id=?
   sql> delete from Ticket where id=?
raw rows: Ticket=1 Agent=2
