From mboxrd@z Thu Jan 1 00:00:00 1970 From: Ian Campbell Subject: [PATCH OSSTEST] mg-show-flight-runvars: avoid "SELECT .. AND TRUE" for sqlite Date: Wed, 17 Feb 2016 10:51:59 +0000 Message-ID: <1455706319-24690-1-git-send-email-ian.campbell@citrix.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Return-path: List-Unsubscribe: , List-Post: List-Help: List-Subscribe: , Sender: xen-devel-bounces@lists.xen.org Errors-To: xen-devel-bounces@lists.xen.org To: ian.jackson@eu.citrix.com, xen-devel@lists.xen.org Cc: Ian Campbell List-Id: xen-devel@lists.xenproject.org c5e29f93fb6e "mg-show-flight-runvars: recurse on buildjobs upon request" broke standalone mode with: Error: no such column: TRUE from sqlite. Do as is done for $syntcond and use (1=1) instead. Signed-off-by: Ian Campbell --- mg-show-flight-runvars | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/mg-show-flight-runvars b/mg-show-flight-runvars index c847456..d708fed 100755 --- a/mg-show-flight-runvars +++ b/mg-show-flight-runvars @@ -53,7 +53,7 @@ our %jobs; sub collect ($;$@) { my ($flight,$jobcond,@jobcondparams) = @_; - $jobcond //= "TRUE"; + $jobcond //= "(1=1)"; $flight =~ m/^\d+/ or $flight = "'$flight'"; my $qfrom = "FROM runvars WHERE flight=$flight AND $synthcond AND $jobcond"; -- 2.6.1