summaryrefslogtreecommitdiffstats
path: root/Bugzilla
diff options
context:
space:
mode:
authorjocuri%softhome.net <>2004-07-31 17:59:16 +0200
committerjocuri%softhome.net <>2004-07-31 17:59:16 +0200
commit7cea397f3ea0988b4edd4b2225fc65bf28b63611 (patch)
treecc816110085482132e5ed31b21dacc377a48d20b /Bugzilla
parent4c1db37570469aef2c7cc9f2ad9f859560ca8851 (diff)
downloadbugzilla-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.
Diffstat (limited to 'Bugzilla')
-rwxr-xr-xBugzilla/Bug.pm2
1 files changed, 1 insertions, 1 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),