Debbie Steigner created TEIIDDES-2865:
-----------------------------------------
Summary: JDBC importer imports MSSQL Server datatype numeric(9,[0-9]) as
bigdecimal with zero precision
Key: TEIIDDES-2865
URL:
https://issues.jboss.org/browse/TEIIDDES-2865
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 9.0.7, 9.0.6, 9.0.5, 10.0
Reporter: Debbie Steigner
Assignee: Barry LaFond
Fix For: 10.0.2
JDBC importer imports MSSQL Server datatype numeric(9,[0-9]) as bigdecimal with zero
precision and should be 9. I believe this
https://issues.jboss.org/browse/TEIIDDES-2746
may have changed the behavior, in version 9.0.3 it imports correctly.
You can use
jdbc:sqlserver://ENGNTDBS14.mw.lab.eng.bos.redhat.com:1433;databaseName=mss_eds
user - mss_eds
password - mss_eds
table - debtest2, both columns are numeric(9,2)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)