dynamobi/dynamobi — Issue #827: [FRG-43] Casting from decimal to char/varchar loses decimal point
Author: dynamobi-build
Created: 2011-12-30 03:51:19+00:00
State: closed
Labels: FRG

[reporter="schoi", created="Wed, 15 Feb 2006 23:46:12 -0500 (GMT-05:00)"]
Repro:

----------

create schema s;

set schema 's';

create table t1 (d decimal(3,1));

insert into t1 values(12.3);

select * from t1;

--

-- +-------+

-- | D |

-- +-------+

-- | 12.3 |

-- +-------+

--

select cast (d as char(10)) from t1;

--

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

-- | EXPR$0 |

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

-- | 123 |

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

--