Hi Pierre,
Can you say more?
Trafodion does support NUMERIC(18,6) as a distinct data type, for example:
>>create table t1 (a int not null, b largeint not null, c numeric(18,6) not
>>null
+> , primary key (a));
--- SQL operation complete.
>>insert into t1 values (1,2,3.8);
--- 1 row(s) inserted.
>>insert into t1 values (4,5,6.712345);
--- 1 row(s) inserted.
>>insert into t1 values (7,8,9.000000001);
--- 1 row(s) inserted.
>>select * From t1;
A B C
----------- -------------------- ---------------------
1 2 3.800000
4 5 6.712345
7 8 9.000000
--- 3 row(s) selected.
>>
It might be useful to do a "showddl" on the underlying Trafodion table to
see what the column data types are. There might, for example, be a problem
in DDL generation so the wrong data type gets created. Or perhaps the DDL is
correct but something happens on the way back out, say for a "describe" of a
statement.
Dave
-----Original Message-----
From: Pierre Smits [mailto:[email protected]]
Sent: Tuesday, March 29, 2016 5:11 AM
To: [email protected]
Subject: NUMERIC? NUMERIC!
Hi all,
While trying to marry Apache OFBiz with Trafodion, I found this oddity:
In OFBiz we type some fields as NUMERIC, e.g:
<field-type-def type="fixed-point" sql-type="NUMERIC(18,6)" java-type=
"java.math.BigDecimal"/>
However, when looking at the feedback we get from Trafodion after a restart
we get:
Column [ESTIMATED_COST] of table [OFBIZ.WORK_EFFORT_GOOD_STANDARD] of entity
[WorkEffortGoodStandard] is of type [BIGINT] in the database, but is defined
as type [NUMERIC] in the entity definition.
Is something wrong inside Trafodion with respect to mapping field types?
Best regards,
Pierre Smits
ORRTIZ.COM <http://www.orrtiz.com>
OFBiz based solutions & services
OFBiz Extensions Marketplace
http://oem.ofbizci.net/oci-2/
