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 r=mkanat, a=justdave --- editproducts.cgi | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'editproducts.cgi') diff --git a/editproducts.cgi b/editproducts.cgi index 9b188f231..13614f269 100755 --- a/editproducts.cgi +++ b/editproducts.cgi @@ -25,6 +25,7 @@ # Gavin Shelley # Fr��ic Buclin # Greg Hendricks +# Lance Larsh # # Direct any questions on this source code to # @@ -624,7 +625,7 @@ if ($action eq 'updategroupcontrols') { foreach my $groupid (@now_na) { my $count = 0; SendSQL("SELECT bugs.bug_id, - (lastdiffed >= delta_ts) + CASE WHEN (lastdiffed >= delta_ts) THEN 1 ELSE 0 END FROM bugs, bug_group_map WHERE group_id = $groupid AND bug_group_map.bug_id = bugs.bug_id @@ -658,7 +659,7 @@ if ($action eq 'updategroupcontrols') { foreach my $groupid (@now_mandatory) { my $count = 0; SendSQL("SELECT bugs.bug_id, - (lastdiffed >= delta_ts) + CASE WHEN (lastdiffed >= delta_ts) THEN 1 ELSE 0 END FROM bugs LEFT JOIN bug_group_map ON bug_group_map.bug_id = bugs.bug_id -- cgit v1.2.3-24-g4f1b