dynamobi/dynamobi — Issue #825: [FRG-45] decimal is sometimes returned as a double
Author: dynamobi-build
Created: 2011-12-30 03:51:10+00:00
State: open
Labels: FRG

[reporter="schoi", created="Thu, 16 Feb 2006 15:28:35 -0500 (GMT-05:00)"]
I guess when S is larger, this happens; insert into a table's decimal column some value, when selecting it out, see that value represented as a double

Repro:

----------

create schema s;

set schema 's';

create table t1(a decimal(10,6) primary key);

insert into t1 values(0);

select * from t1;

--

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

-- | A |

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

-- | 0.000000 |

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

--

create table t2(a decimal(10,7) primary key);

insert into t2 values(0);

select * from t2;

--

-- +-------+

-- | A |

-- +-------+

-- | 0E-7 |

-- +-------+

--