[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

TINYINT type bug

Hello,

I believe the following behavior to be a bug:

create table tinyint_test ( mycol tinyint );

insert into tinyint_test  values (128);

select * from tinyint_test;

The select yields "-128" - looks like we overflowed storage; perhaps
using byte instead of short?
I believe the TINYINT type should handle an 8-bit integer value
between 0 and 255 (signed or unsigned)

Rob Manning

P.S. For your "Other software that supports Mckoi SQL" section, there is the
SQuirreL SQL Client (http://www.squirrelsql.org/index.php?page=faq#faq0)