From nobody Tue Feb 10 03:44:26 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=1596196863; cv=none; d=zohomail.com; s=zohoarc; b=K/xO3pSAKLur5xZ+dFqxgGanuTooEFCdqRa3f8U4OPa61WHgofCqHKkxslfNXvjdkE+kklLaJV3AQPQy2IjlRnV7v6LR+IEzF+G0ieYZ0m147ERS7XHeYzspTDOU4FC4lRW1U74hXNOMTiw18vvu7XlufnYNNHRpXwQF8fatIZ8= ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=zohomail.com; s=zohoarc; t=1596196863; 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=EvrU87VUmhqPQcLcoQxj1pEzDXnicDLvMnlvyon9imw=; b=WCFpFzmTUykt6OCeN+FiMtpt4vbsnCr8xFbfMPhTuGe1GorqDRlFsQbGffFTSJkvVqkWXSHLP8Z5Mlu3zHhjsLnaP4pgckEp6pq5Iap10DDoL2EL1WjALbNhRTnRkGt0iQqeyiWCQs5VIT4MSbE0/tPe9xu4dR5jqLCtzJne2HY= 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 1596196863827320.4276708451257; Fri, 31 Jul 2020 05:01:03 -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 1k1TiL-0001Jt-P9; Fri, 31 Jul 2020 12:00:41 +0000 Received: from us1-rack-iad1.inumbo.com ([172.99.69.81]) by lists.xenproject.org with esmtp (Exim 4.92) (envelope-from ) id 1k1TiK-0001Jk-L8 for xen-devel@lists.xenproject.org; Fri, 31 Jul 2020 12:00:40 +0000 Received: from chiark.greenend.org.uk (unknown [2001:ba8:1e3::]) by us1-rack-iad1.inumbo.com (Halon) with ESMTPS id 737bffed-d325-11ea-8e2b-bc764e2007e4; Fri, 31 Jul 2020 12:00:40 +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 1k1TN1-0001W4-UH; Fri, 31 Jul 2020 12:38:40 +0100 X-Inumbo-ID: 737bffed-d325-11ea-8e2b-bc764e2007e4 From: Ian Jackson To: xen-devel@lists.xenproject.org Subject: [OSSTEST PATCH v2 31/41] schema: Add index to help cs-bisection-step Date: Fri, 31 Jul 2020 12:38:10 +0100 Message-Id: <20200731113820.5765-32-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 Errors-To: xen-devel-bounces@lists.xenproject.org Sender: "Xen-devel" Content-Type: text/plain; charset="utf-8" cs-bisection step basis search involves looking for recent flights that weren't broken. A flight is broken if it has broken steps. Make an index for this to save it scanning the steps table. Signed-off-by: Ian Jackson --- schema/steps-broken-index.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 schema/steps-broken-index.sql diff --git a/schema/steps-broken-index.sql b/schema/steps-broken-index.sql new file mode 100644 index 00000000..770747cc --- /dev/null +++ b/schema/steps-broken-index.sql @@ -0,0 +1,7 @@ +-- ##OSSTEST## 010 Harmless +-- +-- This index helps cs-bisection-flight check if flighss are broken. + +CREATE INDEX steps_broken_idx + ON steps (flight) + WHERE status=3D'broken'; --=20 2.20.1