diff options
author | Christopher Baines <mail@cbaines.net> | 2021-04-02 18:05:02 +0100 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2021-04-02 18:05:02 +0100 |
commit | 99533bb17640c69e486d3e16ce93e88dff146f72 (patch) | |
tree | 0451e2479a6d9df1575e9d16912e7e38891e4d4d | |
parent | de7d3884378c29088bcf2987b702d96f97dd1a82 (diff) | |
download | build-coordinator-99533bb17640c69e486d3e16ce93e88dff146f72.tar build-coordinator-99533bb17640c69e486d3e16ce93e88dff146f72.tar.gz |
Always include derivation join
-rw-r--r-- | guix-build-coordinator/datastore/sqlite.scm | 10 |
1 files changed, 3 insertions, 7 deletions
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 |