From 9a7b1230c5ab1e50199b6e9d2e0044e6e38fe0e4 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 13 Sep 2018 11:26:13 +0200 Subject: bin/get-assignment: add missing join --- bin/get-assignment | 3 +++ 1 file changed, 3 insertions(+) (limited to 'bin/get-assignment') diff --git a/bin/get-assignment b/bin/get-assignment index 89ff155..df80e8b 100755 --- a/bin/get-assignment +++ b/bin/get-assignment @@ -205,6 +205,9 @@ next_building=$( # toolchain package is on that list printf 'DELETE `considered_build_assignments`' printf ' FROM `considered_build_assignments`' + printf ' JOIN `build_assignments`' + printf ' ON `build_assignments`.`id`=`considered_build_assignments`.`id`' + mysql_join_build_assignments_package_sources printf ' WHERE NOT EXISTS (' printf 'SELECT 1 FROM `toolchain_order`' printf ' WHERE `toolchain_order`.`pkgbase`=`package_sources`.`pkgbase`' -- cgit v1.2.3