Fix multiple lines returned for animal on status page
authorKirill Miazine <km@krot.org>
Fri, 25 Nov 2022 00:25:04 +0000 (00:25 +0000)
committerJeremy Harris <jgh@exim.org>
Fri, 25 Nov 2022 00:25:54 +0000 (00:25 +0000)
cgi-bin/show_status.pl

index d14644c0afee7b977401c438709cb9ff95f15735..d52394fec86ff93a8682fd94ddef18dc3da942d8 100755 (executable)
@@ -52,7 +52,9 @@ my $statement =<<EOS;
        b.*,
        s.log_text
   FROM dashboard_mat b LEFT JOIN build_status_log s
-  ON b.snapshot = s.snapshot AND s.log_stage = 'test-results.log'
+  ON    b.sysname = s.sysname
+    AND b.snapshot = s.snapshot
+    AND s.log_stage = 'test-results.log'
   ORDER BY b.branch = 'master' desc,
         b.branch desc, $sort_clause 
         b.snapshot desc