Closed Bug 253357 Opened 20 years ago Closed 20 years ago

IFNULL should be replaced by COALESCE

Categories

(Bugzilla :: Bugzilla-General, defect)

Product:
Bugzilla
Component:
Bugzilla-General
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

()

Status:
RESOLVED FIXED
Milestone:
Bugzilla 2.20

People

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

References

(Blocks 1 open bug)

Details

Attachments

(1 file)

Patch replacing IFNULL with COALESCE
1.76 KB, patch
goobix
: review+
Details | Diff | Splinter Review 
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:
Blocks: bz-postgres, bz-sybase, bz-oracle
Attachment #154534 - Flags: review?
Attachment #154534 - Flags: review? → review+
Assignee: justdave → Tomas.Kopal
Status: UNCONFIRMED → NEW
Ever confirmed: true
Flags: approval?
Target Milestone: --- → Bugzilla 2.20
Flags: approval? → approval+
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
Closed: 20 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.