[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2840) Metadata don't change when swapping H2 for MySQL

Metadata don't change when swapping H2 for MySQL ------------------------------------------------ Key: TEIIDDES-2840 URL: https://issues.jboss.org/browse/TEIIDDES-2840 Project: Teiid Designer Issue Type: Bug Affects Versions: 9.0.1, 9.0.6 Reporter: Matus Makovy Attachments: H2-afterChange.xmi, H2.xmi, MySQL.xmi Issue is copied from bugzilla, it was originally reported by [~skoussou]: Description of problem: Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. Create a Source Model based on H2 (see the https://github.com/DataVirtualizationByExample/DVWorkshop/tree/master/doc... for an example) in the Teiid Designer 2. In the Model Explorer view select the sourcemodel.xmi Right click --> Modelling --> Remove Connection Info 3. Again using the same Right click --> sourcemodel.xmi --> Modelling --> Set Connection Profile and either select the MySQL exisitng profile or create a new one Actual results: An exception occurs when previewing the data with a complaint that there is a MySQL query error (don't have the error avaialble) Expected results: Additional info: Once I delete the model and recreate it with the MySQL connection profile from the beginning the preview works fine. [~mmakovy]: I tried to reproduce this and I got the same error, also with TD 9.0.6.