Bug #17663 documentation typo - tinyint truncation
Submitted: 23 Feb 2006 9:11 Modified: 15 Mar 2006 23:44
Reporter: Jonathan Zylstra Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:4.1, 5.0, 5.1 OS:N/A
Assigned to: Stefan Hinz CPU Architecture:Any

[23 Feb 2006 9:11] Jonathan Zylstra 
Description:
In all 3 versions of the online manuals, the following paragraph [2nd to last] is displayed on the 'numeric-types.html' page. [at least all the english versions]

"For example, when an out-of-range value is assigned to an integer column, MySQL stores the value representing the corresponding endpoint of the column data type range. If you store 256 into a TINYINT or TINYINT UNSIGNED  column, MySQL stores 255 or 127, respectively. When a floating-point or fixed-point column is assigned a value that exceeds the range implied by the specified (or default) precision and scale, MySQL stores the value representing the corresponding endpoint of that range."

The sentence "If you store 256 into a TINYINT or TINYINT UNSIGNED  column, MySQL stores 255 or 127, respectively." is incorrect.

How to repeat:
N/A

Suggested fix:
It should read "If you store 256 into a TINYINT or TINYINT UNSIGNED  column, MySQL stores 127 or 255, respectively." 

The last two values need to be switched - the unsigned types hold the larger values.
[23 Feb 2006 10:15] MySQL Verification Team 
verified and set category to Server: Documentation
[15 Mar 2006 23:44] 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).