bin/return-assignment: remove build assignment from other build slaves, too, if it was a successful one

1 files changed, 5 insertions, 3 deletions

diff --git a/bin/return-assignment b/bin/return-assignment
index 6c0ae16..bf27232 100755
--- a/bin/return-assignment
+++ b/bin/return-assignment
@@ -447,9 +447,11 @@ fi
       printf '%s' "${slave}" | \
         base64 -w0
     )"
-  printf 'UPDATE `build_slaves` SET'
-  printf ' `build_slaves`.`currently_building`=NULL'
-  printf ' WHERE `build_slaves`.`name`=from_base64("%s");\n' \
+  printf 'UPDATE `build_slaves` AS `to_update`'
+  printf ' JOIN `build_slaves` AS `current_slave`'
+  printf ' ON `to_update`.`currently_building`=`current_slave`.`currently_building`'
+  printf ' SET `to_update`.`currently_building`=NULL'
+  printf ' WHERE `current_slave`.`name`=from_base64("%s");\n' \
     "$(
       printf '%s' "${slave}" | \
         base64 -w0