From cff4afaa61ecb1f25d05b0d0982bc49bc756a128 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Fri, 19 Jun 2020 21:09:24 +0100 Subject: Add missing GROUP BY to query --- guix-build-coordinator/datastore/sqlite.scm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/guix-build-coordinator/datastore/sqlite.scm b/guix-build-coordinator/datastore/sqlite.scm index aa65411..16a89da 100644 --- a/guix-build-coordinator/datastore/sqlite.scm +++ b/guix-build-coordinator/datastore/sqlite.scm @@ -737,7 +737,8 @@ WHERE setup_failure_id = :id"))) SELECT derivations.system, COUNT(*) FROM builds INNER JOIN derivations - ON builds.derivation_name = derivations.name"))) + ON builds.derivation_name = derivations.name +GROUP BY derivations.system"))) (let ((result (sqlite-map -- cgit v1.2.3