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