diff options
-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, |