09/10: Update insert-new-latest-status-entries

[Christopher Baines]

cbaines pushed a commit to branch master
in repository data-service.

commit 5124f3be3eb9de0036221832eb506319c8a3d5c7
Author: Christopher Baines <mail@cbaines.net>
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
 )"))