From mboxrd@z Thu Jan  1 00:00:00 1970
From: Ian Jackson <ian.jackson@eu.citrix.com>
Subject: [OSSTEST PATCH 3/7] duration_estimator: Reorganise
	inner SQL query to use WITH
Date: Thu, 11 Aug 2016 17:17:59 +0100
Message-ID: <1470932283-17445-4-git-send-email-ian.jackson@eu.citrix.com>
References: <1470932283-17445-1-git-send-email-ian.jackson@eu.citrix.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64
Return-path: <xen-devel-bounces@lists.xen.org>
Received: from mail6.bemta6.messagelabs.com ([85.158.143.247])
 by lists.xenproject.org with esmtp (Exim 4.84_2)
 (envelope-from <prvs=024b99a10=Ian.Jackson@citrix.com>)
 id 1bXsgW-0002rB-0A
 for xen-devel@lists.xenproject.org; Thu, 11 Aug 2016 16:18:20 +0000
In-Reply-To: <1470932283-17445-1-git-send-email-ian.jackson@eu.citrix.com>
List-Unsubscribe: <https://lists.xen.org/cgi-bin/mailman/options/xen-devel>,
 <mailto:xen-devel-request@lists.xen.org?subject=unsubscribe>
List-Post: <mailto:xen-devel@lists.xen.org>
List-Help: <mailto:xen-devel-request@lists.xen.org?subject=help>
List-Subscribe: <https://lists.xen.org/cgi-bin/mailman/listinfo/xen-devel>,
 <mailto:xen-devel-request@lists.xen.org?subject=subscribe>
Errors-To: xen-devel-bounces@lists.xen.org
Sender: "Xen-devel" <xen-devel-bounces@lists.xen.org>
To: xen-devel@lists.xenproject.org
Cc: Ian Jackson <Ian.Jackson@eu.citrix.com>, Wei Liu <wei.liu2@citrix.com>
List-Id: xen-devel@lists.xenproject.org

V2UgYXJlIGdvaW5nIHRvLCBzb21ldGltZXMsIHdhbnQgdG8gYXNrIG1vcmUgY29tcGxpY2F0ZWQg
cXVlc3Rpb25zCmFib3V0IHRoZSBzdGVwcyBpbiB0aGUgam9iIG9mIGludGVyZXN0LgoKTm8gZnVu
Y3Rpb25hbCBjaGFuZ2UsIGV4Y2VwdCBwZXJoYXBzIHRvIHF1ZXJ5IG9wdGltaXNhdGlvbi4KClNp
Z25lZC1vZmYtYnk6IElhbiBKYWNrc29uIDxJYW4uSmFja3NvbkBldS5jaXRyaXguY29tPgotLS0K
IE9zc3Rlc3QvRXhlY3V0aXZlLnBtIHwgMTMgKysrKysrKysrLS0tLQogMSBmaWxlIGNoYW5nZWQs
IDkgaW5zZXJ0aW9ucygrKSwgNCBkZWxldGlvbnMoLSkKCmRpZmYgLS1naXQgYS9Pc3N0ZXN0L0V4
ZWN1dGl2ZS5wbSBiL09zc3Rlc3QvRXhlY3V0aXZlLnBtCmluZGV4IDExNjAxMmIuLjEwZmRjOGQg
MTAwNjQ0Ci0tLSBhL09zc3Rlc3QvRXhlY3V0aXZlLnBtCisrKyBiL09zc3Rlc3QvRXhlY3V0aXZl
LnBtCkBAIC0xMDU3LDEzICsxMDU3LDE4IEBAIEVORAogICAgICMgcyBKIEogSiAjIGZpeCBwZXJs
LW1vZGUKIAogICAgIG15ICRkdXJhdGlvbl9kdXJhdGlvbl9xdHh0PSA8PEVORDsKLSAgICAgICAg
ICAgIFNFTEVDVCBzdW0oZmluaXNoZWQtc3RhcnRlZCkKLSAgICAgICAgICAgICAgICBBUyBkdXJh
dGlvbgorICAgICAgICBXSVRIIHRzdGVwcyBBUyAKKyAgICAgICAgKAorICAgICAgICAgICAgU0VM
RUNUICoKICAgICAgICAgICAgICAgRlJPTSBzdGVwcwogICAgICAgICAgICAgIFdIRVJFIGZsaWdo
dD0/IEFORCBqb2I9PwotICAgICAgICAgICAgICAgQU5EIHN0ZXAgIT0gJ3RzLWhvc3RzLWFsbG9j
YXRlJworICAgICAgICApCisgICAgICAgICAgICBTRUxFQ1Qgc3VtKGZpbmlzaGVkLXN0YXJ0ZWQp
CisgICAgICAgICAgICAgICAgQVMgZHVyYXRpb24KKyAgICAgICAgICAgICAgRlJPTSB0c3RlcHMK
KyAgICAgICAgICAgICBXSEVSRSBzdGVwICE9ICd0cy1ob3N0cy1hbGxvY2F0ZScKIEVORAotCisJ
CiAgICAgbXkgJGR1cmF0aW9uX2R1cmF0aW9uX3EgPSAkZGJoX3Rlc3RzLT5wcmVwYXJlKCRkdXJh
dGlvbl9kdXJhdGlvbl9xdHh0KTsKIAogICAgIHJldHVybiBzdWIgewotLSAKMi4xLjQKCgpfX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwpYZW4tZGV2ZWwgbWFp
bGluZyBsaXN0Clhlbi1kZXZlbEBsaXN0cy54ZW4ub3JnCmh0dHBzOi8vbGlzdHMueGVuLm9yZy94
ZW4tZGV2ZWwK