@@ -100,14 +100,16 @@ async fn workflow_deletion_removes_both_projections_and_is_scoped_and_retryable(
100100 let other_query = seed ( & db, other, & keys, id, & d_tag, now) . await ;
101101 assert_present ( & db, & query, id) . await ;
102102
103- db. delete_workflow_by_coordinate (
104- community,
105- & Keys :: generate ( ) . public_key ( ) . to_bytes ( ) ,
106- & d_tag,
107- now as i64 ,
108- )
109- . await
110- . expect ( "wrong owner is a no-op" ) ;
103+ let unchanged = db
104+ . delete_workflow_by_coordinate (
105+ community,
106+ & Keys :: generate ( ) . public_key ( ) . to_bytes ( ) ,
107+ & d_tag,
108+ now as i64 ,
109+ )
110+ . await
111+ . expect ( "wrong owner is a no-op" ) ;
112+ assert ! ( !unchanged. changed) ;
111113 assert_present ( & db, & query, id) . await ;
112114
113115 let run_id = create_workflow_run ( & db. pool , community, id, None , None )
@@ -125,18 +127,32 @@ async fn workflow_deletion_removes_both_projections_and_is_scoped_and_retryable(
125127 . execute ( & db. pool )
126128 . await
127129 . expect ( "scheduled claim linked to run" ) ;
128- db. delete_workflow_by_coordinate ( community, & owner, & d_tag, now as i64 )
129- . await
130- . expect ( "delete workflow" ) ;
130+ let ( first, second) = tokio:: join!(
131+ db. delete_workflow_by_coordinate( community, & owner, & d_tag, now as i64 ) ,
132+ db. delete_workflow_by_coordinate( community, & owner, & d_tag, now as i64 ) ,
133+ ) ;
134+ let first = first. expect ( "first deletion" ) ;
135+ let second = second. expect ( "concurrent deletion" ) ;
136+ assert_ne ! (
137+ first. changed, second. changed,
138+ "only one deletion changes state"
139+ ) ;
140+ assert_eq ! (
141+ first. channel_id, None ,
142+ "channel-less mutation still reports change"
143+ ) ;
144+ assert_eq ! ( second. channel_id, None ) ;
131145 assert_absent ( & db, & query, id) . await ;
132146 assert_present ( & db, & other_query, id) . await ;
133147 assert ! ( matches!(
134148 db. get_workflow_run( community, run_id) . await ,
135149 Err ( DbError :: NotFound ( _) )
136150 ) ) ;
137- db. delete_workflow_by_coordinate ( community, & owner, & d_tag, now as i64 )
151+ let unchanged = db
152+ . delete_workflow_by_coordinate ( community, & owner, & d_tag, now as i64 )
138153 . await
139154 . expect ( "repeat deletion" ) ;
155+ assert ! ( !unchanged. changed) ;
140156 assert_absent ( & db, & query, id) . await ;
141157}
142158
@@ -150,9 +166,11 @@ async fn workflow_deletion_preserves_newer_definition_and_cleans_legacy_orphan()
150166 let d_tag = id. to_string ( ) ;
151167 let now = Timestamp :: now ( ) . as_secs ( ) ;
152168 let query = seed ( & db, community, & keys, id, & d_tag, now) . await ;
153- db. delete_workflow_by_coordinate ( community, & owner, & d_tag, now as i64 - 1 )
169+ let unchanged = db
170+ . delete_workflow_by_coordinate ( community, & owner, & d_tag, now as i64 - 1 )
154171 . await
155172 . expect ( "stale deletion" ) ;
173+ assert ! ( !unchanged. changed) ;
156174 assert_present ( & db, & query, id) . await ;
157175
158176 // Old relay releases deleted the executable row, but not the definition.
@@ -166,16 +184,30 @@ async fn workflow_deletion_preserves_newer_definition_and_cleans_legacy_orphan()
166184 . len( ) ,
167185 1
168186 ) ;
169- db. delete_workflow_by_coordinate ( community, & owner, & d_tag, now as i64 )
187+ let repaired = db
188+ . delete_workflow_by_coordinate ( community, & owner, & d_tag, now as i64 )
170189 . await
171190 . expect ( "repair deletion" ) ;
191+ assert ! ( repaired. changed, "orphan-only cleanup must dispatch" ) ;
192+ assert_eq ! ( repaired. channel_id, None ) ;
172193 assert_absent ( & db, & query, id) . await ;
173194
174195 let legacy_id = Uuid :: new_v4 ( ) ;
175196 let legacy = seed ( & db, community, & keys, legacy_id, "legacy-name" , now) . await ;
176- db. delete_workflow_by_coordinate ( community, & owner, "legacy-name" , now as i64 )
197+ db. soft_delete_by_coordinate (
198+ community,
199+ KIND_WORKFLOW_DEF as i32 ,
200+ & owner,
201+ "legacy-name" ,
202+ now as i64 ,
203+ )
204+ . await
205+ . expect ( "remove definition to leave only executable projection" ) ;
206+ let repaired = db
207+ . delete_workflow_by_coordinate ( community, & owner, "legacy-name" , now as i64 )
177208 . await
178209 . expect ( "name coordinate deletion" ) ;
210+ assert ! ( repaired. changed, "projection-only cleanup must dispatch" ) ;
179211 assert_absent ( & db, & legacy, legacy_id) . await ;
180212}
181213
0 commit comments