aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authormkanat%kerio.com <>2005-10-25 02:21:02 +0000
committermkanat%kerio.com <>2005-10-25 02:21:02 +0000
commit46aba0e761e99db24b5de10f13bbc108fdc982a4 (patch)
tree45bc61c7b95fc2d6753c7b6a2ffb3bb1d7ed2254 /chart.cgi
parentBug 313533: editvalues.cgi: Reference found where even-sized list expected at... (diff)
downloadbugzilla-46aba0e761e99db24b5de10f13bbc108fdc982a4.tar.gz
bugzilla-46aba0e761e99db24b5de10f13bbc108fdc982a4.tar.bz2
bugzilla-46aba0e761e99db24b5de10f13bbc108fdc982a4.zip
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
Diffstat (limited to 'chart.cgi')
-rwxr-xr-xchart.cgi4
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");