From d7674caa4f7c5e8faa8db347a49b7fd1bb264e9f Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Sun, 4 Apr 2021 11:18:03 +0100 Subject: Always join against the derivations table As that's now needed for the derivation name in datastore-list-failed-builds-with-blocking-count. --- guix-build-coordinator/datastore/sqlite.scm | 9 +++------ 1 file 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 -- cgit v1.2.3