diff options
| author | jocuri%softhome.net <> | 2004-07-31 17:59:16 +0200 |
|---|---|---|
| committer | jocuri%softhome.net <> | 2004-07-31 17:59:16 +0200 |
| commit | 7cea397f3ea0988b4edd4b2225fc65bf28b63611 (patch) | |
| tree | cc816110085482132e5ed31b21dacc377a48d20b | |
| parent | 4c1db37570469aef2c7cc9f2ad9f859560ca8851 (diff) | |
| download | bugzilla-7cea397f3ea0988b4edd4b2225fc65bf28b63611.tar.gz bugzilla-7cea397f3ea0988b4edd4b2225fc65bf28b63611.tar.xz | |
Patch for bug 253357: replace IFNULL with COALESCE for increased database compatibility; patch by Tomas Kopal <Tomas.Kopal@altap.cz>; r=vladd, a=justdave.
| -rwxr-xr-x | Bugzilla/Bug.pm | 2 | ||||
| -rw-r--r-- | CGI.pl | 2 | ||||
| -rwxr-xr-x | long_list.cgi | 2 |
3 files changed, 3 insertions, 3 deletions
diff --git a/Bugzilla/Bug.pm b/Bugzilla/Bug.pm index 8c0998217..2cac77ed3 100755 --- a/Bugzilla/Bug.pm +++ b/Bugzilla/Bug.pm @@ -143,7 +143,7 @@ sub initBug { reporter, bug_file_loc, short_desc, target_milestone, qa_contact, status_whiteboard, DATE_FORMAT(creation_ts,'%Y.%m.%d %H:%i'), - delta_ts, ifnull(sum(votes.vote_count),0), + delta_ts, COALESCE(SUM(votes.vote_count), 0), reporter_accessible, cclist_accessible, estimated_time, remaining_time from bugs left join votes using(bug_id), @@ -317,7 +317,7 @@ sub GetBugActivity { } my $query = " - SELECT IFNULL(fielddefs.description, bugs_activity.fieldid), + SELECT COALESCE(fielddefs.description, bugs_activity.fieldid), fielddefs.name, bugs_activity.attach_id, DATE_FORMAT(bugs_activity.bug_when,'%Y.%m.%d %H:%i'), diff --git a/long_list.cgi b/long_list.cgi index 657ff9e24..5644a5323 100755 --- a/long_list.cgi +++ b/long_list.cgi @@ -42,7 +42,7 @@ my $cgi = Bugzilla->cgi; my $generic_query = " SELECT bugs.bug_id, - IFNULL(bugs.alias,''), + COALESCE(bugs.alias, ''), products.name, bugs.version, bugs.rep_platform, |