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 /globals.pl | |
| 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 'globals.pl')
| -rw-r--r-- | globals.pl | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/globals.pl b/globals.pl index ebbce4c16..e7e3f7521 100644 --- a/globals.pl +++ b/globals.pl @@ -25,6 +25,7 @@ # Joel Peshkin <bugreport@peshkin.net> # Dave Lawrence <dkl@redhat.com> # Max Kanat-Alexander <mkanat@bugzilla.org> +# Lance Larsh <lance.larsh@oracle.com> # Contains some global variables and routines used throughout bugzilla. @@ -734,7 +735,8 @@ sub get_legal_field_values { sub BugInGroupId { my ($bugid, $groupid) = (@_); PushGlobalSQLState(); - SendSQL("SELECT bug_id != 0 FROM bug_group_map + SendSQL("SELECT CASE WHEN bug_id != 0 THEN 1 ELSE 0 END + FROM bug_group_map WHERE bug_id = $bugid AND group_id = $groupid"); my $bugingroup = FetchOneColumn(); |