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
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