diff options
author | Christopher Baines <mail@cbaines.net> | 2021-04-04 11:18:03 +0100 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2021-04-04 11:18:03 +0100 |
commit | d7674caa4f7c5e8faa8db347a49b7fd1bb264e9f (patch) | |
tree | 28822f120f17b44152b0904187755a2c171c4733 /guix-build-coordinator | |
parent | fe5f7f87f0807b4280d991641d8a60aa963e215f (diff) | |
download | build-coordinator-d7674caa4f7c5e8faa8db347a49b7fd1bb264e9f.tar build-coordinator-d7674caa4f7c5e8faa8db347a49b7fd1bb264e9f.tar.gz |
Always join against the derivations table
As that's now needed for the derivation name in
datastore-list-failed-builds-with-blocking-count.
Diffstat (limited to 'guix-build-coordinator')
-rw-r--r-- | guix-build-coordinator/datastore/sqlite.scm | 9 |
1 files changed, 3 insertions, 6 deletions
diff --git a/guix-build-coordinator/datastore/sqlite.scm b/guix-build-coordinator/datastore/sqlite.scm index d857a31..ea3acba 100644 --- a/guix-build-coordinator/datastore/sqlite.scm +++ b/guix-build-coordinator/datastore/sqlite.scm @@ -775,12 +775,9 @@ FROM ( AND blocked_builds.processed = 0 AND blocked_builds.canceled = 0 ) AS blocking_count - FROM builds" - (if system - " - INNER JOIN derivations ON derivations.id = builds.derivation_id" - "") - " + FROM builds + INNER JOIN derivations + ON derivations.id = builds.derivation_id LEFT JOIN build_results ON builds.id = build_results.build_id WHERE |