[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
02/03: Filter out duplicate ids for blocking builds
From: |
Christopher Baines |
Subject: |
02/03: Filter out duplicate ids for blocking builds |
Date: |
Sun, 2 Jul 2023 05:43:32 -0400 (EDT) |
cbaines pushed a commit to branch master
in repository data-service.
commit d12ae0079ec0f36262bd6ff07ab9ae94f68212f1
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Sun Jul 2 10:42:24 2023 +0100
Filter out duplicate ids for blocking builds
---
guix-data-service/model/blocked-builds.scm | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/guix-data-service/model/blocked-builds.scm
b/guix-data-service/model/blocked-builds.scm
index 10219df..b6f8d69 100644
--- a/guix-data-service/model/blocked-builds.scm
+++ b/guix-data-service/model/blocked-builds.scm
@@ -61,7 +61,7 @@ WITH RECURSIVE all_derivations(id, file_name) AS (
INNER JOIN derivations
ON derivation_inputs.derivation_id = derivations.id
)
-SELECT builds.derivation_output_details_set_id
+SELECT DISTINCT builds.derivation_output_details_set_id
FROM all_derivations
INNER JOIN derivations_by_output_details_set
ON all_derivations.id = derivations_by_output_details_set.derivation_id