]
Debbie Steigner updated TEIIDDES-2850:
--------------------------------------
Affects Version/s: 9.0.3
(was: 9.0)
Import in the Teiid Designer shows incorrect metadata for same tables
exist in multiple schemas
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-2850
URL:
https://issues.jboss.org/browse/TEIIDDES-2850
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 9.0.3
Reporter: Anu Saji
Assignee: Barry LaFond
Attachments: Screenshot_Import_1.png, Screenshot_Import_2.png,
Screenshot_Import_4.png, Screenshot_Import_5.png, Screenshot_Toad.png
In customers words
==============================================================
Hello,
We found an issue with import in the Teiid Designer that shows incorrect metadata for
same tables exist in multiple schemas.
For example, if we want to import table TABLE_A in the SCHEMA_A but if the same table
name is also exist in other database schema in the same database instance, then it is
showing incorrect metadata with schema name.
Please take a look at the attached screenshots that shows importing table AAVALUE in
PMX_SUPER schema shows the table AAVALUE in other database schemas PMX and PMX_GUEST
instead of showing PMX_SUPER irrespective of selecting any of the option in the designer:
- All schema
- Only selected schema
- Select and connection filtered schema
Then, after importing the table, it is creating duplicate columns as shown in the
screenshots.
=========================================================================