diff options
| author | Christopher Baines <mail@cbaines.net> | 2020-06-19 21:09:24 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2020-06-19 21:09:24 +0100 |
| commit | cff4afaa61ecb1f25d05b0d0982bc49bc756a128 (patch) | |
| tree | d01d97fb742e67c3f3dc135a048c7ada08fabcaa | |
| parent | 5a402642db769aaed61accba54c21708cbfd4978 (diff) | |
| download | build-coordinator-cff4afaa61ecb1f25d05b0d0982bc49bc756a128.tar build-coordinator-cff4afaa61ecb1f25d05b0d0982bc49bc756a128.tar.gz | |
Add missing GROUP BY to query
| -rw-r--r-- | guix-build-coordinator/datastore/sqlite.scm | 3 |
1 files changed, 2 insertions, 1 deletions
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 |