dynamobi/dynamobi — Issue #826: [FRG-44] Inserting a decimal that is has too many integral digits does not always give exception
Author: dynamobi-build
Created: 2011-12-30 03:51:14+00:00
State: open
Labels: FRG

[reporter="schoi", created="Thu, 16 Feb 2006 11:29:09 -0500 (GMT-05:00)"]
Repro:

----------

create schema s;

set schema 's';

-- this gives error, for all (P,S) < 19:

create table t1 (a decimal(1,1) primary key);

insert into t1 values(1);

-- > error. good.

-- this does not give error (only P=S=19):

create table t2 (a decimal(19,19) primary key);

insert into t2 values(1);

select * from t2;

--

-- +-------------------------+

-- | A |

-- +-------------------------+

-- | -0.8446744073709551616 |

-- +-------------------------+

--