lib/mysql-functions: mysql_query_remove_old_binary_packages_from_build_list() new

2 files changed, 5 insertions, 0 deletions

diff --git a/bin/get-package-updates b/bin/get-package-updates
index fe9fee7..94f58cb 100755
--- a/bin/get-package-updates
+++ b/bin/get-package-updates
@@ -599,6 +599,8 @@ echo 'Done - mark decisions as final.'
     "${repository_ids__any_build_list}"
   printf ' WHERE `binary_packages_in_repositories`.`repository`=%s;\n' \
     "${repository_ids__any_to_be_decided}"
+  # remove duplicate binary_packages from "build-list"
+  mysql_query_remove_old_binary_packages_from_build_list
 } | \
   mysql_run_query
 
diff --git a/bin/seed-build-list b/bin/seed-build-list
index f1ce16b..432ef6c 100755
--- a/bin/seed-build-list
+++ b/bin/seed-build-list
@@ -591,6 +591,9 @@ if ${update}; then
     mysql_join_binary_packages_binary_packages_in_repositories 'a_bp' 'a_bpir'
     printf ' AND `a_bpir`.`repository`=%s;\n' \
       "${repository_ids__any_build_list}"
+
+    # remove duplicate binary_packages from "build-list"
+    mysql_query_remove_old_binary_packages_from_build_list
   } | \
     mysql_run_query