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 <ian.jack...@eu.citrix.com> --- 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 = <<END; -- 1.7.10.4 _______________________________________________ Xen-devel mailing list Xen-devel@lists.xen.org http://lists.xen.org/xen-devel