Apache OpenOffice (AOO) Bugzilla – Issue 18583
'Value out of range' error for tinyint unsigned columns.
Last modified: 2006-05-31 14:29:06 UTC
When I try to open a table which has columns of type tinyint, attribute unsigned and values greater than 127, I get an error: "Die Dateninhalte konnten nicht geladen werden (data content could not be loaded). Value '143' is out of range [-127,127]." The database is a MySQL database accessed via Connector/J. According to the MySQL documentation, the unsigned range is 0 to 255 (And the signed range is -128 to 127 and not -127 to 127). Therefore 143 is a valid value (Otherwise I could not have entered it into the database anyhow)!
correcting sub component and default owner
Hi, Yes I can reproduce this. Send to the right developer and set target. Bye Marc
Fixed in CWS oj07. OJ->MSC: We have to test any kind of unsigned DataTypes: tinyint, smallint, int, bigint.
change subcomponent to 'none'
verify in CWS oj07
.