cbaines pushed a commit to branch master
in repository data-service.
commit 5124f3be3eb9de0036221832eb506319c8a3d5c7
Author: Christopher Baines <[email protected]>
AuthorDate: Wed Oct 21 20:25:59 2020 +0100
Update insert-new-latest-status-entries
To use the status first for ordering, then the timestamp. This ensures
sensible behaviour regardless of what timestamps are present.
---
guix-data-service/model/build-status.scm | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/guix-data-service/model/build-status.scm
b/guix-data-service/model/build-status.scm
index 5a079a2..ec833b5 100644
--- a/guix-data-service/model/build-status.scm
+++ b/guix-data-service/model/build-status.scm
@@ -120,11 +120,11 @@ WHERE build_id IN ("
WINDOW rows_for_build AS (
PARTITION BY build_id
ORDER BY
- timestamp DESC,
CASE WHEN status = 'scheduled' THEN -2
WHEN status = 'started' THEN -1
ELSE 0
- END DESC
+ END DESC,
+ timestamp DESC
RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
)"))
