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 <Tomas.Kopal@altap.cz>; r=vladd,
 a=justdave.

---
 Bugzilla/Bug.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'Bugzilla')

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