]
Barry LaFond closed TEIIDDES-504.
---------------------------------
Resolution: Out of Date
Getting Started With Designer kit needs updating to fix schema
differences between SQL Server and MySQL
-------------------------------------------------------------------------------------------------------
Key: TEIIDDES-504
URL:
https://issues.jboss.org/browse/TEIIDDES-504
Project: Teiid Designer
Issue Type: Task
Components: Documentation
Reporter: Larry O'Leary
Assignee: Barry LaFond
The Intro to Designer training was originally written to use the MMFinancials schema for
SQL Server. It appears that some data types are not imported the same way when the MySQL
schema is used. This results in data type differences between the written instructions
and the MySQL schema that is most commonly used in the Getting Started kit.
For example, the ProductShares column in the AccountHoldings table is being imported as a
biginteger when using SQL Server but as a bigdecimal when using MySQL. This difference
then results in reconciler/transformation errors due to type incompatibility which require
explicit conversions.