Issue 18583 - 'Value out of range' error for tinyint unsigned columns.
Summary: 'Value out of range' error for tinyint unsigned columns.
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: PC Linux, all
: P2 Trivial with 2 votes (vote)
Target Milestone: OOo 2.0
Assignee: ocke.janssen
QA Contact: issues@dba
Depends on:
Reported: 2003-08-24 16:24 UTC by manfredu
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description manfredu 2003-08-24 16:24:58 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

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)!
Comment 1 Frank Schönheit 2003-08-25 07:38:14 UTC
correcting sub component and default owner
Comment 2 marc.neumann 2003-08-26 14:20:35 UTC

Yes I can reproduce this.
Send to the right developer and set target.

Bye Marc
Comment 3 ocke.janssen 2003-08-27 11:17:11 UTC
Fixed in CWS oj07.

OJ->MSC: We have to test any kind of unsigned DataTypes: tinyint,
smallint, int, bigint.
Comment 4 hans_werner67 2004-02-02 12:20:29 UTC
change subcomponent to 'none'
Comment 5 marc.neumann 2004-03-01 10:22:50 UTC
verify in CWS oj07
Comment 6 ocke.janssen 2004-09-06 12:08:30 UTC