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

---
 chart.cgi | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'chart.cgi')

diff --git a/chart.cgi b/chart.cgi
index 2b8d39b56..566d0541f 100755
--- a/chart.cgi
+++ b/chart.cgi
@@ -19,6 +19,7 @@
 # Rights Reserved.
 #
 # Contributor(s): Gervase Markham <gerv@gerv.net>
+#                 Lance Larsh <lance.larsh@oracle.com>
 
 # Glossary:
 # series:   An individual, defined set of data plotted over time.
@@ -207,7 +208,8 @@ sub assertCanEdit {
     return if UserInGroup("admin");
 
     my $dbh = Bugzilla->dbh;
-    my $iscreator = $dbh->selectrow_array("SELECT creator = ? FROM series " .
+    my $iscreator = $dbh->selectrow_array("SELECT CASE WHEN creator = ? " .
+                                          "THEN 1 ELSE 0 END FROM series " .
                                           "WHERE series_id = ?", undef,
                                           $::userid, $series_id);
     $iscreator || ThrowUserError("illegal_series_edit");
-- 
cgit v1.2.3-24-g4f1b