Bug #8060 | Incorrect INSERT for DOUBLE values on MySQL 5.0.2 | ||
---|---|---|---|
Submitted: | 21 Jan 2005 3:16 | Modified: | 21 Jan 2005 5:22 |
Reporter: | David Nugent | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.0.2 | OS: | FreeBSD (FreeBSD 5.3) |
Assigned to: | Dean Ellis | CPU Architecture: | Any |
[21 Jan 2005 3:16]
David Nugent
[21 Jan 2005 4:17]
David Nugent
Ok, I now believe this to be my error and it simply highlights a difference between versions and how they each cope with and compensate for the error. Specification in the table creation of the width is incorrect and too small; 5.0.1 is truncating the value whereas earlier MySQL versions allowed it without warning.
[21 Jan 2005 5:22]
Dean Ellis
Yes, this is expected. The 5.0.0 behavior you noted looks like an old bug that has (as you see) already been fixed, as you noted. Thanks for the update.