]
Steven Hawkins commented on TEIIDDES-2398:
------------------------------------------
You are basing the above on MySQL I assume. In which case the difference is that Teiid by
default widens unsigned types. See
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)