From 99533bb17640c69e486d3e16ce93e88dff146f72 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Fri, 2 Apr 2021 18:05:02 +0100 Subject: Always include derivation join --- guix-build-coordinator/datastore/sqlite.scm | 10 +++------- 1 file changed, 3 insertions(+), 7 deletions(-) (limited to 'guix-build-coordinator') diff --git a/guix-build-coordinator/datastore/sqlite.scm b/guix-build-coordinator/datastore/sqlite.scm index 03ef4cc..bfa3cea 100644 --- a/guix-build-coordinator/datastore/sqlite.scm +++ b/guix-build-coordinator/datastore/sqlite.scm @@ -1533,13 +1533,9 @@ SELECT id FROM tags WHERE key = :key" (string-append " SELECT uuid, derivations.name, priority, processed, canceled, created_at, end_time -FROM builds" - (if (and (null? systems) - (null? not-systems)) - "" - " -INNER JOIN derivations ON builds.derivation_id = derivations.id") - " +FROM builds +INNER JOIN derivations + ON builds.derivation_id = derivations.id LEFT JOIN ( SELECT build_id, (',' || group_concat(tag_id) || ',') AS tag_string FROM build_tags -- cgit v1.2.3