Issue 18583

Summary:	'Value out of range' error for tinyint unsigned columns.
Product:	Base	Reporter:	manfredu <usselmann.m>
Component:	code	Assignee:	ocke.janssen
Status:	CLOSED FIXED	QA Contact:	issues@dba <issues>
Severity:	Trivial
Priority:	P2	CC:	issues
Version:	OOo 1.1 RC3
Target Milestone:	OOo 2.0
Hardware:	PC
OS:	Linux, all
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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
[-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)!

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

Hi,

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