Robert Manning
2006-12-25 10:53:22 UTC
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)
---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com
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)
---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com