bin/return-assignment: fix typos

1 files changed, 1 insertions, 21 deletions

diff --git a/bin/return-assignment b/bin/return-assignment
index 08e43f8..9ccb80e 100755
--- a/bin/return-assignment
+++ b/bin/return-assignment
@@ -724,6 +724,7 @@ trigger_mirror_refreshs
   printf ' OR `%s`.`architecture`=%s' \
     'early_bp' "${architecture_ids__any}" \
     'binary_packages' "${architecture_ids__any}"
+  printf ';\n'
 
   join_part=$(
     printf ' JOIN `pkg_hashes`'
@@ -769,27 +770,6 @@ trigger_mirror_refreshs
     "${repository_ids__any_build_list}"
   printf 'COMMIT;\n'
 
-  printf ' AND NOT EXISTS ('
-    printf 'SELECT 1 FROM `toolchain_order` AS `late`'
-    printf ' JOIN `toolchain_order` AS `early`'
-    printf ' ON `early`.`number`<`late`.`number`'
-    printf ' AND `early`.`pkgbase`!=`late`.`pkgbase`'
-    printf ' JOIN `package_sources` AS `early_ps`'
-    printf ' ON `early_ps`.`pkgbase`=`early`.`pkgbase`'
-    mysql_join_package_sources_build_assignments 'early_ps' 'early_ba'
-    mysql_join_build_assignments_binary_packages 'early_ba' 'early_bp'
-    mysql_join_binary_packages_binary_packages_in_repositories 'early_bp' 'early_bpir'
-    printf ' AND `early_bpir`.`repository`=%s' \
-      "${repository_ids__any_build_list}"
-    printf ' WHERE `late`.`pkgbase`=`package_sources`.`pkgbase`'
-    printf ' AND ('
-      printf '`early_bp`.`architecture`=`binary_packages`.`architecture`'
-      printf ' OR `%s`.`architecture`=%s' \
-        'early_bp' "${architecture_ids__any}" \
-        'binary_packages' "${architecture_ids__any}"
-    printf ')'
-  printf ');\n'
-
   # update package information
   printf 'UPDATE `binary_packages`'
   printf ' SET'