IFNULL should be replaced by COALESCE

RESOLVED FIXED in Bugzilla 2.20

Status

()

RESOLVED FIXED
15 years ago
5 years ago

People

(Reporter: Tomas.Kopal, Assigned: Tomas.Kopal)

Tracking

(Blocks: 1 bug)

unspecified
Bugzilla 2.20
Dependency tree / graph
Bug Flags:
approval +

Details

Attachments

(1 attachment)

(Assignee)

Description

15 years ago
User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.1) Gecko/20040721 Debian/1.7.1-2
Build Identifier: 

As IFNULL function is MySQL specific, we should replace it by COALESCE, which is
supported by all major databases (checked MySQL, Postgres, Sybase, Oracle).
Patch will follow.

Reproducible: Always
Steps to Reproduce:
(Assignee)

Comment 1

15 years ago
Created attachment 154534 [details] [diff] [review]
Patch replacing IFNULL with COALESCE
(Assignee)

Updated

15 years ago
Blocks: 98304, 173130, 189947
(Assignee)

Updated

15 years ago
Attachment #154534 - Flags: review?

Updated

15 years ago
Attachment #154534 - Flags: review? → review+

Updated

15 years ago
Assignee: justdave → Tomas.Kopal
Status: UNCONFIRMED → NEW
Ever confirmed: true
Flags: approval?
Target Milestone: --- → Bugzilla 2.20
Flags: approval? → approval+

Comment 2

15 years ago
Checking in CGI.pl;
/cvsroot/mozilla/webtools/bugzilla/CGI.pl,v  <--  CGI.pl
new revision: 1.214; previous revision: 1.213
done
Checking in long_list.cgi;
/cvsroot/mozilla/webtools/bugzilla/long_list.cgi,v  <--  long_list.cgi
new revision: 1.39; previous revision: 1.38
done
Checking in Bugzilla/Bug.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/Bug.pm,v  <--  Bug.pm
new revision: 1.42; previous revision: 1.41
done
Status: NEW → RESOLVED
Last Resolved: 15 years ago
Resolution: --- → FIXED
QA Contact: matty_is_a_geek → default-qa
You need to log in before you can comment on or make changes to this bug.