branch master updated: Remove redundant joins from the select build query

[Christopher Baines]

This is an automated email from the git hooks/post-receive script.

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

The following commit(s) were added to refs/heads/master by this push:
     new 851a6c1  Remove redundant joins from the select build query
851a6c1 is described below

commit 851a6c17b56a2f06839c79d914eaaa677a1061f2
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Mon Oct 16 17:19:44 2023 +0100

    Remove redundant joins from the select build query
---
 guix-data-service/model/build.scm | 5 -----
 1 file changed, 5 deletions(-)

diff --git a/guix-data-service/model/build.scm 
b/guix-data-service/model/build.scm
index ea4ce65..1240453 100644
--- a/guix-data-service/model/build.scm
+++ b/guix-data-service/model/build.scm
@@ -317,11 +317,6 @@ SELECT build_servers.url,
 FROM builds
 INNER JOIN build_servers
   ON build_servers.id = builds.build_server_id
-INNER JOIN derivations_by_output_details_set
-  ON builds.derivation_output_details_set_id =
-     derivations_by_output_details_set.derivation_output_details_set_id
-INNER JOIN derivations
-  ON derivations.id = derivations_by_output_details_set.derivation_id
 WHERE build_server_id = $1 AND
       builds.build_server_build_id = $2
 GROUP BY builds.id, build_servers.url, builds.derivation_file_name")