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

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.