diff mbox

[OSSTEST] mg-show-flight-runvars: avoid "SELECT .. AND TRUE" for sqlite

Message ID 1455706319-24690-1-git-send-email-ian.campbell@citrix.com (mailing list archive)
State New, archived
Headers show

Commit Message

Ian Campbell Feb. 17, 2016, 10:51 a.m. UTC 
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 <ian.campbell@citrix.com>
---
 mg-show-flight-runvars | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)
diff mbox

Patch

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";