[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2865) JDBC importer imports MSSQL Server datatype numeric(9, [0-9]) as bigdecimal with zero precision
[
https://issues.jboss.org/browse/TEIIDDES-2865?page=com.atlassian.jira.plu...
]
Matej Kralik reopened TEIIDDES-2865:
------------------------------------
Imported columns have set the value of the numeric precision same as the value of the
length (importedColumns.png) but numeric precision and length of the column are different
values.
In the JDBC importer, the values column_size and decimal_digits are different.
From example:
debtest1 (debTestImport.png)
coulmn id - column_size: 18 - decimal_digits: 0
column bigdecimalvalue - column_size: 9 - decimal_digits: 0
debtest2 (debTest2Import.png)
coulmn id - columnSize: 9 - decimal_digits: 2
column bigdecimalvalue - columnSize: 9 - decimal_digits: 2
I used DB from the description.
In my point of view, the precision value should be set according to decimal_digits.
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: 10.0, 9.0.5, 9.0.6, 9.0.7
Reporter: Debbie Steigner
Assignee: Barry LaFond
Fix For: 11.1, 11.1.1
Attachments: debTest2Import.png, debtestImport.png, importedColumns.png
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
(v7.5.0#75005)