Status: Resolved (View Workflow)
Affects Version/s: 9.1.2
- WildFly 10
- Teiid Server 9.1.2
- CentOs 7
- MySQL 5.6.35
When defining a View with external materialization, if the view does not specify the columns in the same order as they are defined in the Materialized Table, Teiid Server inserts data in the wrong columns (in the order that is defined in the view). It appears that Teiid Server does not use the columns names but instead uses the column indexes.
If the view is defined like this:
And the tables in the database are defined like this:
Then when loadMatView runs, it will insert in country_code column in database the values from cns (view) and in cns column in database the values from country_code (view).
But if the view is defined like this:
Then Teiid will insert the data "correctly".
It appears that loadMatView is using indexes instead of column names to insert the data.