Bug #25173 | incorrect example | ||
---|---|---|---|
Submitted: | 19 Dec 2006 11:54 | Modified: | 20 Dec 2006 11:23 |
Reporter: | Naresh Gupta | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
Version: | 5.0 | OS: | |
Assigned to: | CPU Architecture: | Any |
[19 Dec 2006 11:54]
Naresh Gupta
[19 Dec 2006 13:11]
MySQL Verification Team
Thank you for the bug report. I was unable to find in the online Manual: http://dev.mysql.com/doc/refman/5.0/en/problems-with-null.html The only place I found is: http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html and it is correct: IFNULL(expr1,expr2) If expr1 is not NULL, IFNULL() returns expr1; otherwise it returns expr2. IFNULL() returns a numeric or string value, depending on the context in which it is used. mysql> SELECT IFNULL(1,0); -> 1 mysql> SELECT IFNULL(NULL,10); -> 10 mysql> SELECT IFNULL(1/0,10); -> 10 Could you please point to the exactly URL you found it. Thanks in advance.
[20 Dec 2006 11:16]
Naresh Gupta
It is the same url that you have mentioned: http://dev.mysql.com/doc/refman/5.0/en/problems-with-null.html Scroll down at the bottom of the page, the very last example/lines are the place I was talking about.
[20 Dec 2006 11:23]
MySQL Verification Team
Thank you for the feedback. That is User Comments not Manual Example maybe that user got that result with a bug at that time.