aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2021-03-30 08:41:11 +0100
committerChristopher Baines <mail@cbaines.net>2021-03-30 08:41:11 +0100
commit343bb5be777d1115b8c8ec1693195860746060cf (patch)
treeb25c70107f5df6bc4e1a66fc1076d5f987b33f53
parent6fbbd1bc5fed4030a6873d1bfcfc03b557a04608 (diff)
downloadbuild-coordinator-343bb5be777d1115b8c8ec1693195860746060cf.tar
build-coordinator-343bb5be777d1115b8c8ec1693195860746060cf.tar.gz
Add missing GROUP BY
This was removed in error in 57932a3d80ba6e41bb349487372f990cf56063d1.
-rw-r--r--guix-build-coordinator/datastore/sqlite.scm3
1 files changed, 2 insertions, 1 deletions
diff --git a/guix-build-coordinator/datastore/sqlite.scm b/guix-build-coordinator/datastore/sqlite.scm
index 72c5f75..945864f 100644
--- a/guix-build-coordinator/datastore/sqlite.scm
+++ b/guix-build-coordinator/datastore/sqlite.scm
@@ -2165,7 +2165,8 @@ SELECT builds.uuid, MAX(derived_priority)
FROM builds_with_derived_priority
INNER JOIN builds
ON builds.id = builds_with_derived_priority.id
-WHERE builds.processed = 0"
+WHERE builds.processed = 0
+GROUP BY builds_with_derived_priority.uuid"
#:cache? #t)))
(let ((result (sqlite-fold