LucidDB / luciddb

DEFUNCT: See README
https://github.com/LucidDB/luciddb
Apache License 2.0
52 stars 24 forks source link

[FRG-43] Casting from decimal to char/varchar loses decimal point #827

Closed dynamobi-build closed 12 years ago

dynamobi-build commented 12 years ago

[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 |
-- +-------------+
--

dynamobi-build commented 12 years ago

[author="jpham", created="Thu, 16 Feb 2006 15:42:08 -0500 (GMT-05:00)"] Could not cast from nullable decimal to ... (lu 5488)

dynamobi-build commented 12 years ago

[author="schoi", created="Mon, 20 Feb 2006 21:42:39 -0500 (GMT-05:00)"] tested in //open/luciddb/test/sql/calc/cast/basic.sql