* [PATCH OSSTEST] mg-show-flight-runvars: avoid "SELECT .. AND TRUE" for sqlite
@ 2016-02-17 10:51 Ian Campbell
0 siblings, 0 replies; only message in thread
From: Ian Campbell @ 2016-02-17 10:51 UTC (permalink / raw)
To: ian.jackson, xen-devel; +Cc: Ian Campbell
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 --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
^ permalink raw reply related [flat|nested] only message in thread
only message in thread, other threads:[~2016-02-17 10:51 UTC | newest]
Thread overview: (only message) (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2016-02-17 10:51 [PATCH OSSTEST] mg-show-flight-runvars: avoid "SELECT .. AND TRUE" for sqlite Ian Campbell
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for NNTP newsgroup(s).