diff options
| -rwxr-xr-x | bin/get-package-updates | 7 |
1 files changed, 2 insertions, 5 deletions
diff --git a/bin/get-package-updates b/bin/get-package-updates index 83d8181..21e8a62 100755 --- a/bin/get-package-updates +++ b/bin/get-package-updates @@ -127,7 +127,6 @@ delete_package() { printf 'UPDATE `binary_packages`' mysql_join_binary_packages_build_assignments mysql_join_build_assignments_package_sources - printf ' LEFT' mysql_join_binary_packages_binary_packages_in_repositories # shellcheck disable=SC2154 printf ' SET `binary_packages`.`repository`=%s,' \ @@ -136,7 +135,7 @@ delete_package() { printf '`binary_packages_in_repositories`.`repository`=%s' \ "${repository_ids__any_deletion_list}" # shellcheck disable=SC2154 - printf ' WHERE `binary_packages`.`repository` in (%s,%s)' \ + printf ' WHERE `binary_packages_in_repositories`.`repository` in (%s,%s)' \ "${repository_ids__any_build_list}" \ "${repository_ids__any_to_be_decided}" printf ' AND `package_sources`.`pkgbase`=from_base64("%s");\n' \ @@ -595,14 +594,12 @@ echo 'Done - mark decisions as final.' done # move binary_packages from "to-be-decided" to "build-list" printf 'UPDATE `binary_packages`' - mysql_join_binary_packages_binary_packages_in_repositories '' 'from_bir' - printf ' LEFT' mysql_join_binary_packages_binary_packages_in_repositories printf ' SET `binary_packages`.`repository`=%s,' \ "${repository_ids__any_build_list}" printf '`binary_packages_in_repositories`.`repository`=%s' \ "${repository_ids__any_build_list}" - printf ' WHERE `from_bir`.`repository`=%s;\n' \ + printf ' WHERE `binary_packages_in_repositories`.`repository`=%s;\n' \ "${repository_ids__any_to_be_decided}" } | \ mysql_run_query |