We are going to need this as part of our data reuse cache key, so we
need it this early. This change hardly slows the query down.
Signed-off-by: Ian Jackson <ian.jackson@eu.citrix.com>
---
sg-report-host-history | 8 ++++----
1 file changed, 4 insertions(+), 4 deletions(-)
diff --git a/sg-report-host-history b/sg-report-host-history
index d47784d9..81a7a8d8 100755
--- a/sg-report-host-history
+++ b/sg-report-host-history
@@ -122,8 +122,9 @@ sub mainquery () {
our @params = keys %hosts;
our $runvarq //= db_prepare(<<END);
- SELECT flight, job, name, val
+ SELECT flight, job, name, val, status
FROM runvars
+ JOIN jobs USING (flight, job)
WHERE $namecond
AND ($valcond)
AND $flightcond
@@ -186,10 +187,9 @@ sub reporthost ($) {
END
our $infoq //= db_prepare(<<END);
- SELECT blessing, branch, intended, status
+ SELECT blessing, branch, intended
FROM flights
- JOIN jobs USING (flight)
- WHERE flight=? AND job=?
+ WHERE flight=? AND ?!='X'
END
our $allocdq //= db_prepare(<<END);
--
2.11.0
_______________________________________________
Xen-devel mailing list
Xen-devel@lists.xenproject.org
https://lists.xenproject.org/mailman/listinfo/xen-devel