diff options
| author | Erich Eckner <git@eckner.net> | 2018-10-17 15:14:46 +0200 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-10-17 15:14:46 +0200 |
| commit | af7a7ff715860a8d1e9037b700c7b5e9d839264e (patch) | |
| tree | f8d64800127eb19ee3336672927874c5a0ac381b | |
| parent | 66eca9e7c18c3c62a056ccd27a626b2148945a7a (diff) | |
| download | builder-af7a7ff715860a8d1e9037b700c7b5e9d839264e.tar.xz | |
bin/build-master-status: Left-join the tables
| -rwxr-xr-x | bin/build-master-status | 4 |
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(' |