[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
06/06: Remove unnecessary join in select-outputs-without-known-nar-entri
From: |
Christopher Baines |
Subject: |
06/06: Remove unnecessary join in select-outputs-without-known-nar-entries |
Date: |
Tue, 13 Oct 2020 15:18:04 -0400 (EDT) |
cbaines pushed a commit to branch master
in repository data-service.
commit 7936ca2e54f84d9d9d545c845c1536c3417ab217
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Tue Oct 13 19:45:41 2020 +0100
Remove unnecessary join in select-outputs-without-known-nar-entries
---
guix-data-service/model/nar.scm | 6 ++----
1 file changed, 2 insertions(+), 4 deletions(-)
diff --git a/guix-data-service/model/nar.scm b/guix-data-service/model/nar.scm
index a0be879..b9fe215 100644
--- a/guix-data-service/model/nar.scm
+++ b/guix-data-service/model/nar.scm
@@ -378,9 +378,7 @@ ORDER BY COUNT(*) DESC")
(string-append
"
SELECT DISTINCT derivation_output_details.path, derivation_output_details.id
-FROM derivations
-INNER JOIN derivation_outputs
- ON derivations.id = derivation_outputs.derivation_id
+FROM derivation_outputs
INNER JOIN derivation_output_details
ON derivation_outputs.derivation_output_details_id =
derivation_output_details.id
WHERE derivation_output_details.path NOT IN (
@@ -400,7 +398,7 @@ WHERE derivation_output_details.path NOT IN (
""
(string-append
"
- AND derivations.id IN (
+ AND derivation_outputs.derivation_id IN (
-- Select outputs that are in the relevant revisions
SELECT derivation_id
FROM package_derivations
- branch master updated (4231f11 -> 7936ca2), Christopher Baines, 2020/10/13
- 04/06: Switch queries across to use latest_build_status, Christopher Baines, 2020/10/13
- 01/06: Include package details for the package derivation outputs JSON, Christopher Baines, 2020/10/13
- 06/06: Remove unnecessary join in select-outputs-without-known-nar-entries,
Christopher Baines <=
- 05/06: Display backtraces when exceptions occur for fetching builds, Christopher Baines, 2020/10/13
- 02/06: Include the revision in the package derivation outputs JSON, Christopher Baines, 2020/10/13
- 03/06: Add a latest_build_status table, Christopher Baines, 2020/10/13