Bug #31394 | Using tinyint with zerofill in DECLARE changes -1 to 000. | ||
---|---|---|---|
Submitted: | 4 Oct 2007 11:59 | Modified: | 4 Oct 2007 15:24 |
Reporter: | Horst Hunger | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Data Types | Severity: | S2 (Serious) |
Version: | 5.1.23 | OS: | Linux (Suse 10.2) |
Assigned to: | CPU Architecture: | Any |
[4 Oct 2007 11:59]
Horst Hunger
[4 Oct 2007 15:24]
Horst Hunger
Just read the sentence in the ref man: If you specify ZEROFILL for a numeric column, MySQL automatically adds the UNSIGNED attribute to the column. So, I change the state to 'no bug'.