From 6ab57ae83ccc30eade1c1ad069b18856571c339c Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Mon, 14 May 2018 16:19:31 +0200 Subject: bin/get-package-updates: set binary_packages_in_repositories.repository correctly at the end --- bin/get-package-updates | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'bin/get-package-updates') 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"' -- cgit v1.2.3-54-g00ecf