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

[Van Halbert (JIRA)]

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

Van Halbert reassigned TEIID-983:
---------------------------------

    Assignee: Van Halbert


> Getting Started With Designer kit needs updating to fix schema differences between SQL Server and MySQL
> -------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-983
>                 URL: https://jira.jboss.org/jira/browse/TEIID-983
>             Project: Teiid
>          Issue Type: Task
>          Components: Documentation
>    Affects Versions: 7.1
>            Reporter: Larry O'Leary
>            Assignee: Van Halbert
>
> 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/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira