diff options
| author | Christopher Baines <mail@cbaines.net> | 2023-07-02 10:42:24 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2023-07-02 10:42:24 +0100 |
| commit | d12ae0079ec0f36262bd6ff07ab9ae94f68212f1 (patch) | |
| tree | 43e7ca703a9be64fe22c930da043ba79e0310932 | |
| parent | 742949cc97907de96afc72846c155c79ab332cf6 (diff) | |
| download | data-service-d12ae0079ec0f36262bd6ff07ab9ae94f68212f1.tar data-service-d12ae0079ec0f36262bd6ff07ab9ae94f68212f1.tar.gz | |
Filter out duplicate ids for blocking builds
| -rw-r--r-- | guix-data-service/model/blocked-builds.scm | 2 |
1 files changed, 1 insertions, 1 deletions
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 |