Bug #71002 | IFNULL of plain function parameter always latter argument | ||
---|---|---|---|
Submitted: | 25 Nov 2013 13:44 | Modified: | 28 Nov 2013 17:01 |
Reporter: | Programmer Old | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 5.5.8-log, 5.6.16, 5.5.35, 5.1.71 | OS: | Windows (XP, Vista) |
Assigned to: | CPU Architecture: | Any |
[25 Nov 2013 13:44]
Programmer Old
[25 Nov 2013 17:49]
Sveta Smirnova
Thank you for the report. Which results do you expect?
[25 Nov 2013 20:58]
Programmer Old
The result with argument "eld + 0" is the expected. But it comes to me that maybe this is a case that I already reported, #68688, where IFNULL s context is not passed to its arguments (although IF s context is), and the SET is interpreted not in number form but string. Combined with MySQL s too great willingness to convert character string to 0, quite unintuitive.
[28 Nov 2013 17:01]
Sveta Smirnova
Thank you for the feedback. Verified as described. This can be duplicate of another bug, but I leave it as a separate one for now.