diff options
| author | mkanat%kerio.com <> | 2005-10-25 04:21:02 +0200 |
|---|---|---|
| committer | mkanat%kerio.com <> | 2005-10-25 04:21:02 +0200 |
| commit | 46aba0e761e99db24b5de10f13bbc108fdc982a4 (patch) | |
| tree | 45bc61c7b95fc2d6753c7b6a2ffb3bb1d7ed2254 /editproducts.cgi | |
| parent | a637b882206ae3dc5fd6101da96bb6ee0ca53260 (diff) | |
| download | bugzilla-46aba0e761e99db24b5de10f13bbc108fdc982a4.tar.gz bugzilla-46aba0e761e99db24b5de10f13bbc108fdc982a4.tar.xz | |
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 'editproducts.cgi')
| -rwxr-xr-x | editproducts.cgi | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/editproducts.cgi b/editproducts.cgi index 9b188f231..13614f269 100755 --- a/editproducts.cgi +++ b/editproducts.cgi @@ -25,6 +25,7 @@ # Gavin Shelley <bugzilla@chimpychompy.org> # Fr��ic Buclin <LpSolit@gmail.com> # Greg Hendricks <ghendricks@novell.com> +# Lance Larsh <lance.larsh@oracle.com> # # 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 |