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 /Bugzilla | |
| 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.
Diffstat (limited to 'Bugzilla')
| -rwxr-xr-x | Bugzilla/Bug.pm | 2 |
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), |