[teiid-issues] [JBoss JIRA] Updated: (TEIID-983) Getting Started With Designer kit needs updating to fix schema differences between SQL Server and MySQL

[Ramesh Reddy (JIRA)]

     [ https://jira.jboss.org/browse/TEIID-983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramesh Reddy updated TEIID-983:
-------------------------------

    Fix Version/s: 7.1


> Getting Started With Designer kit needs updating to fix schema differences between SQL Server and MySQL
> -------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-983
>                 URL: https://jira.jboss.org/browse/TEIID-983
>             Project: Teiid
>          Issue Type: Task
>          Components: Documentation
>    Affects Versions: 7.1
>            Reporter: Larry O'Leary
>            Assignee: Van Halbert
>             Fix For: 7.1
>
>
> 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. 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira