Bug #9764 | IFNULL truncates data | ||
---|---|---|---|
Submitted: | 8 Apr 2005 15:07 | Modified: | 8 Jun 2005 15:51 |
Reporter: | Stefano Crimi' | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Command-line Clients | Severity: | S2 (Serious) |
Version: | 5.0.3alpha | OS: | Windows (Windows 2000/Linux) |
Assigned to: | Alexey Botchkov | CPU Architecture: | Any |
[8 Apr 2005 15:07]
Stefano Crimi'
[8 Apr 2005 15:36]
MySQL Verification Team
Verified also on Linux. Thank you for the bug report.
[3 Jun 2005 22:50]
Stefano Crimi'
I have checked on the new 5.0.6beta version, and I have discovered that the bug appears only when the field is a text field (char or varchar) longer the 30 characters: therefore, if the field length is set to 30 (or less), the bug doesn't appear, which starting from a length of 31, the bug appears, resulting in a truncation of the result.
[8 Jun 2005 15:49]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/25759
[8 Jun 2005 15:51]
Alexey Botchkov
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release. If necessary, you can access the source repository and build the latest available version, including the bugfix, yourself. More information about accessing the source trees is available at http://www.mysql.com/doc/en/Installing_source_tree.html