Message ID | 1470932283-17445-4-git-send-email-ian.jackson@eu.citrix.com (mailing list archive) |
---|---|
State | New, archived |
Headers | show |
diff --git a/Osstest/Executive.pm b/Osstest/Executive.pm index 116012b..10fdc8d 100644 --- a/Osstest/Executive.pm +++ b/Osstest/Executive.pm @@ -1057,13 +1057,18 @@ END # s J J J # fix perl-mode my $duration_duration_qtxt= <<END; - SELECT sum(finished-started) - AS duration + WITH tsteps AS + ( + SELECT * FROM steps WHERE flight=? AND job=? - AND step != 'ts-hosts-allocate' + ) + SELECT sum(finished-started) + AS duration + FROM tsteps + WHERE step != 'ts-hosts-allocate' END - + my $duration_duration_q = $dbh_tests->prepare($duration_duration_qtxt); return sub {
We are going to, sometimes, want to ask more complicated questions about the steps in the job of interest. No functional change, except perhaps to query optimisation. Signed-off-by: Ian Jackson <Ian.Jackson@eu.citrix.com> --- Osstest/Executive.pm | 13 +++++++++---- 1 file changed, 9 insertions(+), 4 deletions(-)