From af7a7ff715860a8d1e9037b700c7b5e9d839264e Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Wed, 17 Oct 2018 15:14:46 +0200
Subject: bin/build-master-status: Left-join the tables

---
 bin/build-master-status | 4 ++--
 1 file 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('
-- 
cgit v1.2.3-70-g09d2