]
Mark Drilling updated TEIIDDES-2398:
------------------------------------
Attachment: MySQL_BQT_DDL.ddl
We are processing the DDL from teiid. For example on the MySQL 'MediumB' table
the DDL specifies the IntKey type as 'long'. See attached DDL. Need to check
with teiid about the DDL generation and processing
Inconsistent column datatypes when importing
--------------------------------------------
Key: TEIIDDES-2398
URL:
https://issues.jboss.org/browse/TEIIDDES-2398
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export, Modeling
Reporter: Andrej Šmigala
Assignee: Mark Drilling
Fix For: 9.1, 9.0.2, 8.6.2
Attachments: datatypes.png, MySQL_BQT_DDL.ddl
There are multiple discrepancies in the column datatypes when importing using JDBC
importer vs when using Teiid Connection importer.
Also some of the imported datatypes seem completely wrong (e.g. bigdecimal for almost all
numeric datatypes in oracle)