summaryrefslogtreecommitdiff
path: root/bin/get-assignment
diff options
context:
space:
mode:
Diffstat (limited to 'bin/get-assignment')
-rwxr-xr-xbin/get-assignment9
1 files changed, 6 insertions, 3 deletions
diff --git a/bin/get-assignment b/bin/get-assignment
index 3fc0d49..27a266a 100755
--- a/bin/get-assignment
+++ b/bin/get-assignment
@@ -253,10 +253,12 @@ next_building=$(
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 'SELECT 1'
+ printf ' FROM `toolchain_order`'
printf ' WHERE `toolchain_order`.`pkgbase`=`package_sources`.`pkgbase`'
printf ') AND EXISTS ('
- printf 'SELECT 1 FROM `considered_build_assignments_2`'
+ printf 'SELECT 1'
+ printf ' FROM `considered_build_assignments_2`'
printf ' JOIN `build_assignments`'
printf ' ON `build_assignments`.`id`=`considered_build_assignments_2`.`id`'
mysql_join_build_assignments_package_sources
@@ -282,7 +284,8 @@ next_building=$(
printf 'DELETE `considered_build_assignments`'
printf ' FROM `considered_build_assignments`'
printf ' WHERE EXISTS ('
- printf 'SELECT 1 FROM `considered_build_assignments_2`'
+ printf 'SELECT 1'
+ printf ' FROM `considered_build_assignments_2`'
printf ' JOIN `build_assignments`'
printf ' ON `build_assignments`.`id`=`considered_build_assignments_2`.`id`'
mysql_join_build_assignments_package_sources