From mboxrd@z Thu Jan 1 00:00:00 1970 From: Ian Jackson Subject: [OSSTEST PATCH 09/33] standalone mode: Fix two SQL `TRUE's Date: Thu, 17 Sep 2015 18:37:36 +0100 Message-ID: <1442511480-32587-10-git-send-email-ian.jackson@eu.citrix.com> References: <1442511480-32587-1-git-send-email-ian.jackson@eu.citrix.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Return-path: Received: from mail6.bemta3.messagelabs.com ([195.245.230.39]) by lists.xen.org with esmtp (Exim 4.72) (envelope-from ) id 1Zcd8P-0006Lr-UF for xen-devel@lists.xenproject.org; Thu, 17 Sep 2015 17:38:14 +0000 In-Reply-To: <1442511480-32587-1-git-send-email-ian.jackson@eu.citrix.com> List-Unsubscribe: , List-Post: List-Help: List-Subscribe: , Sender: xen-devel-bounces@lists.xen.org Errors-To: xen-devel-bounces@lists.xen.org To: xen-devel@lists.xenproject.org Cc: Ian Jackson , Ian Campbell List-Id: xen-devel@lists.xenproject.org SQL has no portable boolean true literal (really). SQLite3 does not understand `TRUE'. Use `1=1' instead. This means that mg-show-flight-runvars -a will work in standalone mode. Signed-off-by: Ian Jackson --- v2: New patch --- mg-show-flight-runvars | 2 +- sg-report-flight | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/mg-show-flight-runvars b/mg-show-flight-runvars index 62d5cba..e33a3f0 100755 --- a/mg-show-flight-runvars +++ b/mg-show-flight-runvars @@ -33,7 +33,7 @@ for (;;) { $_ = shift @ARGV; last if m/^\-\-?$/; if (m/^-a$/) { - $synthcond = 'TRUE'; + $synthcond = '(1=1)'; } else { die "$_ ?"; } diff --git a/sg-report-flight b/sg-report-flight index a88379a..ef3fd6b 100755 --- a/sg-report-flight +++ b/sg-report-flight @@ -176,7 +176,7 @@ END } my @flightsq_params; - my $flightsq_jobcond='TRUE'; + my $flightsq_jobcond='(1=1)'; if (defined $job) { push @flightsq_params, $job; $flightsq_jobcond = <