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.

---
 request.cgi | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'request.cgi')

diff --git a/request.cgi b/request.cgi
index 43be69856..e330c2c83 100755
--- a/request.cgi
+++ b/request.cgi
@@ -81,8 +81,8 @@ sub queue {
     # should not have access.
     "            COUNT(DISTINCT ugmap.group_id) AS cntuseringroups, 
                 COUNT(DISTINCT bgmap.group_id) AS cntbugingroups, 
-                ((COUNT(DISTINCT ccmap.who) AND cclist_accessible) 
-                  OR ((bugs.reporter = $::userid) AND bugs.reporter_accessible) 
+                ((COUNT(DISTINCT ccmap.who) AND cclist_accessible = 1) 
+                  OR ((bugs.reporter = $::userid) AND bugs.reporter_accessible = 1) 
                   OR bugs.assigned_to = $::userid ) AS canseeanyway 
     " . 
     # Use the flags and flagtypes tables for information about the flags,
-- 
cgit v1.2.3-24-g4f1b