Numeric Bug?

It appears as though 0.0 has a bigger value?

I am running redhar 6.5.2 rpms (RH6).



DROP
create table example(       other      decimal(4,4)
);
CREATE

insert into example         (other) values(3.9);
ERROR:  overflow on numeric ABS(value) >= 10^0 for field with precision
4 scale 4
insert into example         (other) values(0.0);
ERROR:  overflow on numeric ABS(value) >= 10^0 for field with precision
4 scale 4
insert into example         (other) values(0.1);
INSERT 49645 1
insert into example         (other) values(0.1234);
INSERT 49710 1

I can insert 0.1 but not 0.0?

This cannot be right!  This works for Solid and mysql!

Is there a workaround?
-- 
Zot O'Connor

www.ZotConsulting.com
www.WhiteKnightHackers.com