liu ming created TRAFODION-3189:
-----------------------------------
Summary: numeric round value different for INSERT vs UPDATE
Key: TRAFODION-3189
URL: https://issues.apache.org/jira/browse/TRAFODION-3189
Project: Apache Trafodion
Issue Type: Bug
Reporter: liu ming
Assignee: liu ming
create TABLE t_de (id numeric(18,2));
INSERT INTO t_de values(1);
INSERT INTO t_de values(2);
SELECT * FROM t_de ;
ID
--------------------
4.66
--- 1 row(s) selected.
SQL>UPDATE t_de SET id=43997;
--- 1 row(s) updated.
SQL>SELECT * FROM t_de ;
ID
--------------------
439.97
create table t_de01(id numeric(18,3));
create TABLE t_de (id numeric(18,2));
insert into t_de01 values(43997);
select * from t_de;
insert into t_de select round(log10(id),2) from t_de01 where id=43997.000;
select * from t_de;
--------------------
4.63
SQL>select round(log10(id),2) from t_de01 where id=43997.000;
(EXPR)
------------------------
4.64
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
