bin/get-package-updates: set binary_packages_in_repositories.repository correctly at the end

1 files changed, 8 insertions, 1 deletions

diff --git a/bin/get-package-updates b/bin/get-package-updates
index f20ee27..eb45ffd 100755
--- a/bin/get-package-updates
+++ b/bin/get-package-updates
@@ -592,7 +592,14 @@ echo 'Done - mark decisions as final.'
   # move binary_packages from "to-be-decided" to "build-list"
   printf 'UPDATE `binary_packages`'
   mysql_join_binary_packages_repositories '' 'from_repo'
-  printf ' SET `repository`=('
+  printf ' LEFT'
+  mysql_join_binary_packages_binary_packages_in_repositories
+  printf ' SET `binary_packages`.`repository`=('
+    printf 'SELECT `to_repo`.`id`'
+    printf ' FROM `repositories` AS `to_repo`'
+    printf ' WHERE `to_repo`.`name`="build-list"'
+  printf '),'
+  printf ' `binary_packages_in_repositories`.`repository`=('
     printf 'SELECT `to_repo`.`id`'
     printf ' FROM `repositories` AS `to_repo`'
     printf ' WHERE `to_repo`.`name`="build-list"'