From 00cc8677e25a98e81d70757cc02991e63ee3b975 Mon Sep 17 00:00:00 2001
From: "jocuri%softhome.net" <>
Date: Sat, 3 Jul 2004 07:26:28 +0000
Subject: Patch for bug 248001: Conversion of boolean conditions in SQL
 statements for better DB independence; patch by David Lawrence
 <dkl@redhat.com>; r=joel, vladd; a=justdave.

---
 Bugzilla/Bug.pm | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'Bugzilla/Bug.pm')

diff --git a/Bugzilla/Bug.pm b/Bugzilla/Bug.pm
index bef512e0f..91cd0d8c8 100755
--- a/Bugzilla/Bug.pm
+++ b/Bugzilla/Bug.pm
@@ -342,11 +342,11 @@ sub groups {
              " LEFT JOIN user_group_map" .
              " ON user_group_map.group_id = groups.id" .
              " AND user_id = $::userid" .
-             " AND NOT isbless" .
+             " AND isbless = 0" .
              " LEFT JOIN group_control_map" .
              " ON group_control_map.group_id = groups.id" .
              " AND group_control_map.product_id = " . $self->{'product_id'} .
-             " WHERE isbuggroup");
+             " WHERE isbuggroup = 1");
 
     while (&::MoreSQLData()) {
         my ($groupid, $name, $description, $ison, $ingroup, $isactive,
-- 
cgit v1.2.3-24-g4f1b