diff options
| author | Christopher Baines <mail@cbaines.net> | 2023-10-16 17:19:44 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2023-10-16 17:19:44 +0100 |
| commit | 851a6c17b56a2f06839c79d914eaaa677a1061f2 (patch) | |
| tree | 220ef2b0107d43cb15114e58ed40f901b59fc5ef | |
| parent | 82bb17470044d536f57b799a9feea54435544c3f (diff) | |
| download | data-service-851a6c17b56a2f06839c79d914eaaa677a1061f2.tar data-service-851a6c17b56a2f06839c79d914eaaa677a1061f2.tar.gz | |
Remove redundant joins from the select build query
| -rw-r--r-- | guix-data-service/model/build.scm | 5 |
1 files changed, 0 insertions, 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") |