01/04: Tweak the select-required-builds-that-failed query

[Christopher Baines]

cbaines pushed a commit to branch master
in repository data-service.

commit 1fd5c8e379d2ada26ddcc8414eeb6d2b1a4bdf0f
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Sat Dec 26 10:00:35 2020 +0000

    Tweak the select-required-builds-that-failed query
    
    I think this makes a little more sense.
---
 guix-data-service/model/build.scm | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/guix-data-service/model/build.scm 
b/guix-data-service/model/build.scm
index 3041b67..b2ac79f 100644
--- a/guix-data-service/model/build.scm
+++ b/guix-data-service/model/build.scm
@@ -356,14 +356,14 @@ SELECT all_derivations.file_name, 
latest_build_status.status
 FROM all_derivations
 INNER JOIN derivations_by_output_details_set
   ON all_derivations.id = derivations_by_output_details_set.derivation_id
-LEFT OUTER JOIN builds
+INNER JOIN builds
   ON derivations_by_output_details_set.derivation_output_details_set_id =
      builds.derivation_output_details_set_id
  AND builds.build_server_id = $2
-LEFT OUTER JOIN latest_build_status
+INNER JOIN latest_build_status
   ON builds.id = latest_build_status.build_id
-WHERE latest_build_status.status = 'failed'
-  AND NOT EXISTS (
+ AND latest_build_status.status = 'failed'
+WHERE NOT EXISTS (
     SELECT 1
     FROM builds AS successful_builds
     INNER JOIN build_status AS successful_builds_build_status