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 /process_bug.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 'process_bug.cgi')
| -rwxr-xr-x | process_bug.cgi | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/process_bug.cgi b/process_bug.cgi index dc119179c..9f556cc0a 100755 --- a/process_bug.cgi +++ b/process_bug.cgi @@ -25,6 +25,7 @@ # Myk Melez <myk@mozilla.org> # Jeff Hedlund <jeff.hedlund@matrixsi.com> # Frédéric Buclin <LpSolit@gmail.com> +# Lance Larsh <lance.larsh@oracle.com> # Implementation notes for this file: # @@ -1730,7 +1731,8 @@ foreach my $id (@idlist) { SendSQL("SELECT DISTINCT groups.id, isactive, " . "oldcontrolmap.membercontrol, newcontrolmap.membercontrol, " . "CASE WHEN groups.id IN ($grouplist) THEN 1 ELSE 0 END, " . - "bug_group_map.group_id IS NOT NULL " . + "CASE WHEN bug_group_map.group_id IS NOT NULL " . + "THEN 1 ELSE 0 END " . "FROM groups " . "LEFT JOIN group_control_map AS oldcontrolmap " . "ON oldcontrolmap.group_id = groups.id " . |