 -- 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 888.67
+--  999.6666666 is allowed and it should be rounded to 999.67
 --
 --
 -- Results from MySql are completely wrong with respect to this semantics.

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

insert into test values (-12.12);
insert into test values (123.12);
insert into test values (-123.12);
      -- next value should be rounded to 123.12
insert into test values (123.123);
      -- next value should be rounded to -123.12
insert into test values (-123.123);
      -- next value should be rounded to 123.13
insert into test values (123.128);
     -- next value 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 for the next value 
insert into test values (-1234);
      -- a '.00' decimal part is assumed for the next value 
insert into test values (1234.1);
insert into test values (-1234.1);

