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

1 files changed, 3 insertions, 1 deletions

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");