If you think a bug might affect users in the 57 release, please set the correct tracking and status flags for Release Management.

IFNULL should be replaced by COALESCE

RESOLVED FIXED in Bugzilla 2.20

Status

()

Bugzilla
Bugzilla-General
RESOLVED FIXED
13 years ago
3 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

13 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

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

Updated

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

Updated

13 years ago
Attachment #154534 - Flags: review?

Updated

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

Updated

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

Comment 2

13 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: 13 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.