From e70abd21bab68b23488f7ef1ee2e693a3b365691 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Tue, 18 May 2010 18:49:59 +0000
Subject: import rt 3.8.8

---
 rt/lib/RT/Interface/Web/QueryBuilder/Tree.pm | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

(limited to 'rt/lib/RT/Interface/Web/QueryBuilder/Tree.pm')

diff --git a/rt/lib/RT/Interface/Web/QueryBuilder/Tree.pm b/rt/lib/RT/Interface/Web/QueryBuilder/Tree.pm
index 574ead465..e672d8e4c 100755
--- a/rt/lib/RT/Interface/Web/QueryBuilder/Tree.pm
+++ b/rt/lib/RT/Interface/Web/QueryBuilder/Tree.pm
@@ -268,7 +268,11 @@ sub ParseSQL {
         }
 
         $value =~ s/'/\\'/g;
-        $value = "'$value'" if $value =~ /[^0-9]/;
+        if ( lc $op eq 'is' || lc $op eq 'is not' ) {
+            $value = 'NULL'; # just fix possible mistakes here
+        } elsif ( $value !~ /^[+-]?[0-9]+$/ ) {
+            $value = "'$value'";
+        }
         $key = "'$key'" if $key =~ /^CF./;
 
         my $clause = { Key => $key, Op => $op, Value => $value };
-- 
cgit v1.2.1