From 46aba0e761e99db24b5de10f13bbc108fdc982a4 Mon Sep 17 00:00:00 2001
From: "mkanat%kerio.com" <>
Date: Tue, 25 Oct 2005 02:21:02 +0000
Subject: Bug 313209: Oracle requires "CASE WHEN" around boolean expressions in
 the SELECT column list Patch By Lance Larsh <lance.larsh@oracle.com>
 r=mkanat, a=justdave

---
 globals.pl | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'globals.pl')

diff --git a/globals.pl b/globals.pl
index ebbce4c16..e7e3f7521 100644
--- a/globals.pl
+++ b/globals.pl
@@ -25,6 +25,7 @@
 #                 Joel Peshkin <bugreport@peshkin.net>
 #                 Dave Lawrence <dkl@redhat.com>
 #                 Max Kanat-Alexander <mkanat@bugzilla.org>
+#                 Lance Larsh <lance.larsh@oracle.com>
 
 # Contains some global variables and routines used throughout bugzilla.
 
@@ -734,7 +735,8 @@ sub get_legal_field_values {
 sub BugInGroupId {
     my ($bugid, $groupid) = (@_);
     PushGlobalSQLState();
-    SendSQL("SELECT bug_id != 0 FROM bug_group_map
+    SendSQL("SELECT CASE WHEN bug_id != 0 THEN 1 ELSE 0 END
+            FROM bug_group_map
             WHERE bug_id = $bugid
             AND group_id = $groupid");
     my $bugingroup = FetchOneColumn();
-- 
cgit v1.2.1