Mailing List Archive

[OSSTEST PATCH v2 29/41] sg-report-host-history: Drop a redundznt AND clause
This condition is the same as $flightcond. (This has no effect on the
db performance since the query planner figures it out, but it is
confusing.)

Signed-off-by: Ian Jackson <ian.jackson@eu.citrix.com>
---
sg-report-host-history | 3 +--
1 file changed, 1 insertion(+), 2 deletions(-)

diff --git a/sg-report-host-history b/sg-report-host-history
index 2ca0e235..f4352fc3 100755
--- a/sg-report-host-history
+++ b/sg-report-host-history
@@ -175,13 +175,12 @@ sub mainquery ($) {
AND val = ?
AND $flightcond
AND $restrictflight_cond
- AND flight > ?
ORDER BY flight DESC
LIMIT $limit * 2
END

print DEBUG "MAINQUERY $host...\n";
- $runvarq->execute($host, $minflight);
+ $runvarq->execute($host);

$hosts{$host} = $runvarq->fetchall_arrayref({});
print DEBUG "MAINQUERY $host got ".(scalar @{ $hosts{$host} })."\n";
--
2.20.1