From a446e1976d2d03146501869c35cd1fb8ed149eed Mon Sep 17 00:00:00 2001
From: Byron Jones <glob@mozilla.com>
Date: Thu, 11 Sep 2014 22:08:44 +0800
Subject: Bug 1064678: searching for tracking flag "is empty" is generating
 incorrect sql

---
 extensions/TrackingFlags/Extension.pm | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

(limited to 'extensions/TrackingFlags')

diff --git a/extensions/TrackingFlags/Extension.pm b/extensions/TrackingFlags/Extension.pm
index 33cac7b9d..a1b5a0ef6 100644
--- a/extensions/TrackingFlags/Extension.pm
+++ b/extensions/TrackingFlags/Extension.pm
@@ -510,7 +510,12 @@ sub _tracking_flags_search_nonchanged {
 
     push(@$joins, $bugs_join);
 
-    $args->{'full_field'} = "COALESCE($bugs_alias.value, '---')";
+    if ($operator eq 'isempty' or $operator eq 'isnotempty') {
+        $args->{'full_field'} = "$bugs_alias.value";
+    }
+    else {
+        $args->{'full_field'} = "COALESCE($bugs_alias.value, '---')";
+    }
 }
 
 sub bug_end_of_create {
-- 
cgit v1.2.3-24-g4f1b