From 7cea397f3ea0988b4edd4b2225fc65bf28b63611 Mon Sep 17 00:00:00 2001 From: "jocuri%softhome.net" <> Date: Sat, 31 Jul 2004 15:59:16 +0000 Subject: Patch for bug 253357: replace IFNULL with COALESCE for increased database compatibility; patch by Tomas Kopal ; r=vladd, a=justdave. --- Bugzilla/Bug.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'Bugzilla/Bug.pm') 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), -- cgit v1.2.3-24-g4f1b