 -- 'decimal' and 'numeric' data types should be equivalent.
--- 'dec' is a synonym of 'decimal'
+-- 'dec' is a synonym for 'decimal'
 --
 -- SEMANTICS: 
 --

insert into test values (-12.12);
insert into test values (123.12);
insert into test values (-123.12);
      -- should be rounded to 123.12
insert into test values (123.123);
      -- should be rounded to -123.12
insert into test values (-123.123);
      -- should be rounded to 123.13
insert into test values (123.128);
     -- should be rounded to -123.13
insert into test values (-123.128);


-- these should fail
insert into test values (1234);
      -- a '.00' decimal part is assumed here
insert into test values (-1234);
      -- a '.00' decimal part is assumed here
insert into test values (1234.1);
insert into test values (-1234.1);


-- Example: 
--  The allowed range of decimal numbers for dec(5,2) is (-999.99 , 999.99).
--  1000 is not allowed, as the integer part is 4 digits long, which exceeds (5 - 2)=3 
--  999.6666666 is allowed and it should be rounded to 999.67
--
--
-- Results from MySql are completely wrong with respect to this semantics.
