Bug #1499 | INSERT/UPDATE into decimal field rounding problem | ||
---|---|---|---|
Submitted: | 7 Oct 2003 11:04 | Modified: | 30 Jan 2004 22:00 |
Reporter: | Rumen Telbizov | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 3.23.x 4.0.x | OS: | FreeBSD (FreeBSD 4.8-STABLE) |
Assigned to: | Paul DuBois | CPU Architecture: | Any |
[7 Oct 2003 11:04]
Rumen Telbizov
[12 Oct 2003 10:38]
MySQL Verification Team
I get the same result on Suse 8.2.
[3 Nov 2003 10:00]
Sergei Golubchik
you are right - on INSERT values are not rounded the same way as ROUND does - we'll clarify this in the manual.
[30 Jan 2004 22:00]
Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant product(s). Additional info: I've updated the passage to say: When such a column is assigned a value with more digits following the decimal point than are allowed by the specified scale, the value is converted to that scale. (The precise behavior is operating-system specific, but generally the effect is truncation to the allowable number of digits.)