From nobody Tue Nov 4 11:28:12 2025 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=pass(p=none dis=none) header.from=xenproject.org ARC-Seal: i=1; a=rsa-sha256; t=1602095272; cv=none; d=zohomail.com; s=zohoarc; b=QkT/Bjou9LYSPvmAPqZgdCVyLibjABp6JDgviQ0A6y9WrlPfZbLMLuwt7561RnV04dXzu082wyb1kXa2RB6a7HkqLkbOJdrdZOQm/flIhGi8b7sveYd66pH6Z5Qta5sfZlQHb6+P1LXZT7DXQWn+1p6ZqYeDK6bSvxQRK6IQY1I= ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=zohomail.com; s=zohoarc; t=1602095272; 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=NEnCwrRsDmYxHtSBbAcrJuxTiYWV6JzrK9KYj//hxUw=; b=S2Ki2HEfzbHjx/BCehbVQjjWSeceveHKsrSMv1zP/FX5gi+1bwBBlKRzqnsMLSqykVRhwgFirI5ndFzKhMmwN2DyptN+xpRLdAYa1vzkpkQ2lcDpH0wocGOG6tARb5TFGhP5C8SSTc9lvlmuOIqZj/ulQTZ3FCCKiIYg2tFWq28= 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=pass 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 1602095272061578.0712980555925; Wed, 7 Oct 2020 11:27:52 -0700 (PDT) Received: from list by lists.xenproject.org with outflank-mailman.3701.10978 (Exim 4.92) (envelope-from ) id 1kQEA4-00032C-VX; Wed, 07 Oct 2020 18:27:36 +0000 Received: by outflank-mailman (output) from mailman id 3701.10978; Wed, 07 Oct 2020 18:27:36 +0000 Received: from localhost ([127.0.0.1] helo=lists.xenproject.org) by lists.xenproject.org with esmtp (Exim 4.92) (envelope-from ) id 1kQEA4-00030S-01; Wed, 07 Oct 2020 18:27:36 +0000 Received: by outflank-mailman (input) for mailman id 3701; Wed, 07 Oct 2020 18:27:31 +0000 Received: from us1-rack-iad1.inumbo.com ([172.99.69.81]) by lists.xenproject.org with esmtp (Exim 4.92) (envelope-from ) id 1kQE4w-00072Q-Mt for xen-devel@lists.xenproject.org; Wed, 07 Oct 2020 18:22:18 +0000 Received: from chiark.greenend.org.uk (unknown [2001:ba8:1e3::]) by us1-rack-iad1.inumbo.com (Halon) with ESMTPS id 6c4a2380-59ee-4efa-b349-fac56b8f829b; Wed, 07 Oct 2020 18:20:31 +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 1kQDkC-0007CF-Eb; Wed, 07 Oct 2020 19:00:52 +0100 Received: from us1-rack-iad1.inumbo.com ([172.99.69.81]) by lists.xenproject.org with esmtp (Exim 4.92) (envelope-from ) id 1kQE4w-00072Q-Mt for xen-devel@lists.xenproject.org; Wed, 07 Oct 2020 18:22:18 +0000 Received: from chiark.greenend.org.uk (unknown [2001:ba8:1e3::]) by us1-rack-iad1.inumbo.com (Halon) with ESMTPS id 6c4a2380-59ee-4efa-b349-fac56b8f829b; Wed, 07 Oct 2020 18:20:31 +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 1kQDkC-0007CF-Eb; Wed, 07 Oct 2020 19:00:52 +0100 X-Outflank-Mailman: Message body and most headers restored to incoming version X-BeenThere: xen-devel@lists.xenproject.org List-Id: Xen developer discussion List-Unsubscribe: , List-Post: List-Help: List-Subscribe: , Errors-To: xen-devel-bounces@lists.xenproject.org Precedence: list Sender: "Xen-devel" X-Inumbo-ID: 6c4a2380-59ee-4efa-b349-fac56b8f829b From: Ian Jackson To: xen-devel@lists.xenproject.org Cc: Ian Jackson , Ian Jackson Subject: [OSSTEST PATCH 78/82] flight other job reporting: Put nulls last in the report Date: Wed, 7 Oct 2020 19:00:20 +0100 Message-Id: <20201007180024.7932-79-iwj@xenproject.org> X-Mailer: git-send-email 2.20.1 In-Reply-To: <20201007180024.7932-1-iwj@xenproject.org> References: <20201007180024.7932-1-iwj@xenproject.org> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" From: Ian Jackson Cosmetic change only, but this makes the results easier to understand. Signed-off-by: Ian Jackson --- sg-report-flight | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/sg-report-flight b/sg-report-flight index 2a79db13..d8829932 100755 --- a/sg-report-flight +++ b/sg-report-flight @@ -1434,7 +1434,10 @@ END SELECT * FROM r_elided ORDER BY tident, hostname, kind_sort, - finished, prep_started, rest_started, flight, job, oidents, + prep_started NULLS LAST, + rest_started NULLS LAST, + finished NULLS LAST, + flight, job, oidents, sort_index END =20 --=20 2.20.1