summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-10-17 15:14:46 +0200
committerErich Eckner <git@eckner.net>2018-10-17 15:14:46 +0200
commitaf7a7ff715860a8d1e9037b700c7b5e9d839264e (patch)
treef8d64800127eb19ee3336672927874c5a0ac381b
parent66eca9e7c18c3c62a056ccd27a626b2148945a7a (diff)
downloadbuilder-af7a7ff715860a8d1e9037b700c7b5e9d839264e.tar.xz
bin/build-master-status: Left-join the tables
-rwxr-xr-xbin/build-master-status4
1 files changed, 2 insertions, 2 deletions
diff --git a/bin/build-master-status b/bin/build-master-status
index 16d6c5a..76e755a 100755
--- a/bin/build-master-status
+++ b/bin/build-master-status
@@ -132,7 +132,7 @@ if [ ! -s "${work_dir}/build-master-sanity" ]; then
'tested_packages_count'
printf '`architectures`.`id`'
printf ' FROM `architectures`'
- printf ' JOIN ('
+ printf ' LEFT JOIN ('
printf 'SELECT'
printf ' COUNT('
printf 'DISTINCT `build_assignments`.`id`'
@@ -189,7 +189,7 @@ if [ ! -s "${work_dir}/build-master-sanity" ]; then
mysql_join_build_assignments_build_dependency_loops
printf ') AS `ba_q`'
printf ' ON `ba_q`.`architecture`=`architectures`.`id`'
- printf ' JOIN ('
+ printf ' LEFT JOIN ('
printf 'SELECT'
printf ' SUM('
printf 'IF('