aboutsummaryrefslogtreecommitdiff
path: root/guix-build-coordinator
diff options
context:
space:
mode:
Diffstat (limited to 'guix-build-coordinator')
-rw-r--r--guix-build-coordinator/datastore/sqlite.scm10
1 files changed, 5 insertions, 5 deletions
diff --git a/guix-build-coordinator/datastore/sqlite.scm b/guix-build-coordinator/datastore/sqlite.scm
index bc349d9..7cc66fe 100644
--- a/guix-build-coordinator/datastore/sqlite.scm
+++ b/guix-build-coordinator/datastore/sqlite.scm
@@ -3662,17 +3662,17 @@ UNION
FROM relevant_builds
INNER JOIN builds AS relevant_builds_full
ON relevant_builds.id = relevant_builds_full.id
+ INNER JOIN derivation_inputs
+ ON relevant_builds_full.derivation_id = derivation_inputs.derivation_id
INNER JOIN derivation_outputs
- ON relevant_builds_full.derivation_id = derivation_outputs.derivation_id
+ ON derivation_inputs.derivation_output_id = derivation_outputs.id
INNER JOIN unbuilt_outputs
ON unbuilt_outputs.output_id = derivation_outputs.output_id
INNER JOIN derivation_outputs AS all_derivation_outputs
- ON all_derivation_outputs.output_id = derivation_outputs.output_id
- INNER JOIN derivation_inputs
- ON derivation_inputs.derivation_output_id = all_derivation_outputs.id
+ ON all_derivation_outputs.output_id = unbuilt_outputs.output_id
INNER JOIN builds
ON builds.processed = 0
- AND builds.derivation_id = derivation_inputs.derivation_id
+ AND builds.derivation_id = all_derivation_outputs.derivation_id
)
SELECT build_id
FROM relevant_builds