From nobody Mon Feb 9 16:18:28 2026 Delivered-To: importer@patchew.org Received-SPF: pass (zohomail.com: domain of lists.xenproject.org designates 192.237.175.120 as permitted sender) client-ip=192.237.175.120; envelope-from=xen-devel-bounces@lists.xenproject.org; helo=lists.xenproject.org; Authentication-Results: mx.zohomail.com; spf=pass (zohomail.com: domain of lists.xenproject.org designates 192.237.175.120 as permitted sender) smtp.mailfrom=xen-devel-bounces@lists.xenproject.org; dmarc=fail(p=none dis=none) header.from=eu.citrix.com ARC-Seal: i=1; a=rsa-sha256; t=1596196890; cv=none; d=zohomail.com; s=zohoarc; b=AEbEbofeDkY9mUHGwZqva6TZDK0dWWS6mw2qgfrL+IBR2dK8dlR10mR+auHaGNi/Ovw7eCN4VY4bbZ+vCEroNGqab0bkyOckDGEOsuU4LY4iLawThctBRtsGSH6DoR3m97nDayTXGTMD7mY5eigVjAECDAjHd6pVCzRPNcHDqkg= ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=zohomail.com; s=zohoarc; t=1596196890; h=Content-Transfer-Encoding:Cc:Date:From:In-Reply-To:List-Subscribe:List-Post:List-Id:List-Help:List-Unsubscribe:MIME-Version:Message-ID:References:Sender:Subject:To; bh=unNca1UAgxCc88OP+9qiXjYMDPl4dnvmRYc/yl4ICqM=; b=K1zA6wwszGeZGkmZtF+8KWUpqBlxXMBMvIoWqVvxSmBDIkG26hjpOevYsP1po9JVNO7h30mu9GgeMlKs5LGPVie9Qo1S8gpkBLemBlgrhH70Wl6cML9aXA+EqXfOgK3zCXg3aZAetSr87dCB16iDdEFIQaOlChK8QognKF4IUTg= ARC-Authentication-Results: i=1; mx.zohomail.com; spf=pass (zohomail.com: domain of lists.xenproject.org designates 192.237.175.120 as permitted sender) smtp.mailfrom=xen-devel-bounces@lists.xenproject.org; dmarc=fail header.from= (p=none dis=none) header.from= Return-Path: Received: from lists.xenproject.org (lists.xenproject.org [192.237.175.120]) by mx.zohomail.com with SMTPS id 1596196889804395.84097417918963; Fri, 31 Jul 2020 05:01:29 -0700 (PDT) Received: from localhost ([127.0.0.1] helo=lists.xenproject.org) by lists.xenproject.org with esmtp (Exim 4.92) (envelope-from ) id 1k1Tin-0001Rg-S7; Fri, 31 Jul 2020 12:01:09 +0000 Received: from us1-rack-iad1.inumbo.com ([172.99.69.81]) by lists.xenproject.org with esmtp (Exim 4.92) (envelope-from ) id 1k1Tim-0001R9-5A for xen-devel@lists.xenproject.org; Fri, 31 Jul 2020 12:01:08 +0000 Received: from chiark.greenend.org.uk (unknown [2001:ba8:1e3::]) by us1-rack-iad1.inumbo.com (Halon) with ESMTPS id 83774e7d-d325-11ea-8e2b-bc764e2007e4; Fri, 31 Jul 2020 12:01:07 +0000 (UTC) Received: from [172.18.45.5] (helo=zealot.relativity.greenend.org.uk) by chiark.greenend.org.uk (Debian Exim 4.84_2 #1) with esmtp (return-path ijackson@chiark.greenend.org.uk) id 1k1TMu-0001W4-4C; Fri, 31 Jul 2020 12:38:32 +0100 X-Inumbo-ID: 83774e7d-d325-11ea-8e2b-bc764e2007e4 From: Ian Jackson To: xen-devel@lists.xenproject.org Subject: [OSSTEST PATCH v2 16/41] duration_estimator: Return job column in first query Date: Fri, 31 Jul 2020 12:37:55 +0100 Message-Id: <20200731113820.5765-17-ian.jackson@eu.citrix.com> X-Mailer: git-send-email 2.20.1 In-Reply-To: <20200731113820.5765-1-ian.jackson@eu.citrix.com> References: <20200731113820.5765-1-ian.jackson@eu.citrix.com> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable X-BeenThere: xen-devel@lists.xenproject.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: Xen developer discussion List-Unsubscribe: , List-Post: List-Help: List-Subscribe: , Cc: Ian Jackson , George Dunlap Errors-To: xen-devel-bounces@lists.xenproject.org Sender: "Xen-devel" Content-Type: text/plain; charset="utf-8" Right now this is pointless since the Perl code doesn't need it. But this row is going to be part of a WITH clause soon. No functional change. Diffs to two example queries (from the Perl DBI trace): SELECT f.flight AS flight, + j.job AS job, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=3Dr.flight AND r.name=3D? WHERE j.job=3Dr.job AND f.blessing=3D? AND f.branch=3D? AND j.job=3D? AND r.val=3D? AND (j.status=3D'pass' OR j.status=3D'fail' OR j.status=3D'truncated'!) AND f.started IS NOT NULL AND f.started >=3D ? ORDER BY f.started DESC SELECT f.flight AS flight, + s.job AS job, NULL as started, NULL as status, max(s.finished) AS max_finished FROM steps s JOIN flights f ON s.flight=3Df.flight WHERE s.job=3D? AND f.blessing=3D? AND f.branch=3D? AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >=3D ? - GROUP BY f.flight + GROUP BY f.flight, s.job ORDER BY max_finished DESC CC: George Dunlap Signed-off-by: Ian Jackson --- Osstest/Executive.pm | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/Osstest/Executive.pm b/Osstest/Executive.pm index d45d6557..359120c0 100644 --- a/Osstest/Executive.pm +++ b/Osstest/Executive.pm @@ -1148,6 +1148,7 @@ sub duration_estimator ($$;$$) { } my $recentflights_qtxt=3D <=3D ? - GROUP BY f.flight + GROUP BY f.flight, s.job ORDER BY max_finished DESC END # s J J J # fix perl-mode --=20 2.20.1