From patchwork Thu Aug 11 16:17:59 2016 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Ian Jackson X-Patchwork-Id: 9275533 Return-Path: Received: from mail.wl.linuxfoundation.org (pdx-wl-mail.web.codeaurora.org [172.30.200.125]) by pdx-korg-patchwork.web.codeaurora.org (Postfix) with ESMTP id 929A260231 for ; Thu, 11 Aug 2016 16:20:43 +0000 (UTC) Received: from mail.wl.linuxfoundation.org (localhost [127.0.0.1]) by mail.wl.linuxfoundation.org (Postfix) with ESMTP id 862BF286BE for ; Thu, 11 Aug 2016 16:20:43 +0000 (UTC) Received: by mail.wl.linuxfoundation.org (Postfix, from userid 486) id 7B11228718; Thu, 11 Aug 2016 16:20:43 +0000 (UTC) X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on pdx-wl-mail.web.codeaurora.org X-Spam-Level: X-Spam-Status: No, score=-4.2 required=2.0 tests=BAYES_00, RCVD_IN_DNSWL_MED autolearn=ham version=3.3.1 Received: from lists.xenproject.org (lists.xenproject.org [192.237.175.120]) (using TLSv1.2 with cipher AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by mail.wl.linuxfoundation.org (Postfix) with ESMTPS id 33853286BE for ; Thu, 11 Aug 2016 16:20:42 +0000 (UTC) Received: from localhost ([127.0.0.1] helo=lists.xenproject.org) by lists.xenproject.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bXsgX-0002ud-Mr; Thu, 11 Aug 2016 16:18:21 +0000 Received: from mail6.bemta6.messagelabs.com ([85.158.143.247]) by lists.xenproject.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bXsgW-0002rB-0A for xen-devel@lists.xenproject.org; Thu, 11 Aug 2016 16:18:20 +0000 Received: from [193.109.254.147] by server-4.bemta-6.messagelabs.com id D3/5D-07858-B45ACA75; Thu, 11 Aug 2016 16:18:19 +0000 X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFuplkeJIrShJLcpLzFFi42JxWrrBXtdr6Zp wgzPbbCy+b5nM5MDocfjDFZYAxijWzLyk/IoE1ozzX5YzFmzjqNh4fj5TA2MDWxcjJ4eEgL/E otYHYDabgK5E05a/QDYHh4iAisTtvQYgJrNAicTfD1IgFcIC4RK/Jr5mBbFZBFQlZt67DWbzC nhK9B67zQQxUU7i/PGfzCCtnAJeEvt3iYGEhYBKnu7dzQISFhJQk5i7Ph6iU1Di5MwnLCA2s4 CExMEXL5ghpnBL3D49lXkCI98sJGWzkJQtYGRaxahRnFpUllqka2iql1SUmZ5RkpuYmaNraGC ml5taXJyYnpqTmFSsl5yfu4kRGEwMQLCD8duygEOMkhxMSqK8wjGrw4X4kvJTKjMSizPii0pz UosPMcpwcChJ8IouWRMuJFiUmp5akZaZAwxrmLQEB4+SCK8QSJq3uCAxtzgzHSJ1ilFRSpxXC iQhAJLIKM2Da4PF0iVGWSlhXkagQ4R4ClKLcjNLUOVfMYpzMCoJ8xqATOHJzCuBm/4KaDET0O ITZmCLSxIRUlINjOmZ+V+m9Nw7ckbtWmaKbd+dPxVTmQKXrd56w5SLMcN8Tc31PZaTL+1Rr1J fIbWL1+XtepuAqZk9c0NZ82cKml9flC3zSLtt95ZHl/gU665slK3cPfXxpdgrUY3mE6InqEtL 9R9TLSqzTLJe/dOjUbP+RJzUnAWHW/gtlFJzszcssP9afXitgxJLcUaioRZzUXEiAPoE9OugA gAA X-Env-Sender: prvs=024b99a10=Ian.Jackson@citrix.com X-Msg-Ref: server-9.tower-27.messagelabs.com!1470932296!53544456!1 X-Originating-IP: [66.165.176.63] X-SpamReason: No, hits=0.0 required=7.0 tests=sa_preprocessor: VHJ1c3RlZCBJUDogNjYuMTY1LjE3Ni42MyA9PiAzMDYwNDg=\n, received_headers: No Received headers X-StarScan-Received: X-StarScan-Version: 8.84; banners=-,-,- X-VirusChecked: Checked Received: (qmail 53844 invoked from network); 11 Aug 2016 16:18:18 -0000 Received: from smtp02.citrix.com (HELO SMTP02.CITRIX.COM) (66.165.176.63) by server-9.tower-27.messagelabs.com with RC4-SHA encrypted SMTP; 11 Aug 2016 16:18:18 -0000 X-IronPort-AV: E=Sophos;i="5.28,505,1464652800"; d="scan'208";a="379518885" From: Ian Jackson To: Date: Thu, 11 Aug 2016 17:17:59 +0100 Message-ID: <1470932283-17445-4-git-send-email-ian.jackson@eu.citrix.com> X-Mailer: git-send-email 2.1.4 In-Reply-To: <1470932283-17445-1-git-send-email-ian.jackson@eu.citrix.com> References: <1470932283-17445-1-git-send-email-ian.jackson@eu.citrix.com> MIME-Version: 1.0 X-DLP: MIA2 Cc: Ian Jackson , Wei Liu Subject: [Xen-devel] [OSSTEST PATCH 3/7] duration_estimator: Reorganise inner SQL query to use WITH X-BeenThere: xen-devel@lists.xen.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: Xen developer discussion List-Unsubscribe: , List-Post: List-Help: List-Subscribe: , Errors-To: xen-devel-bounces@lists.xen.org Sender: "Xen-devel" X-Virus-Scanned: ClamAV using ClamSMTP 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 --- Osstest/Executive.pm | 13 +++++++++---- 1 file changed, 9 insertions(+), 4 deletions(-) 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= <prepare($duration_duration_qtxt); return sub {