[JBoss JIRA] (TEIIDDES-2850) Import in the Teiid Designer shows incorrect metadata for same tables exist in multiple schemas
by Debbie Steigner (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2850?page=com.atlassian.jira.plu... ]
Debbie Steigner updated TEIIDDES-2850:
--------------------------------------
Issue Type: Bug (was: Feature Request)
> 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
> 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.
> =========================================================================
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 11 months
[JBoss JIRA] (TEIIDDES-2850) Import in the Teiid Designer shows incorrect metadata for same tables exist in multiple schemas
by Anu Saji (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2850?page=com.atlassian.jira.plu... ]
Anu Saji updated TEIIDDES-2850:
-------------------------------
Attachment: Screenshot_Import_1.png
Screenshot_Import_5.png
Screenshot_Import_2.png
Screenshot_Import_4.png
Screenshot_Toad.png
> 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: Feature Request
> Components: Import/Export
> Affects Versions: 9.0
> Reporter: Anu Saji
> 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.
> =========================================================================
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 11 months
[JBoss JIRA] (TEIIDDES-2850) Import in the Teiid Designer shows incorrect metadata for same tables exist in multiple schemas
by Anu Saji (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2850?page=com.atlassian.jira.plu... ]
Anu Saji updated TEIIDDES-2850:
-------------------------------
Comment: was deleted
(was: A comment with security level 'JBoss Employee' was removed.)
> 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: Feature Request
> Components: Import/Export
> Affects Versions: 9.0
> Reporter: Anu Saji
>
> 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.
> =========================================================================
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 11 months
[JBoss JIRA] (TEIIDDES-2850) Import in the Teiid Designer shows incorrect metadata for same tables exist in multiple schemas
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2850?page=com.atlassian.jira.plu... ]
Matus Makovy commented on TEIIDDES-2850:
----------------------------------------
[~asaji] Could you please attach the screenshots that are mentioned in the text?
> 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: Feature Request
> Components: Import/Export
> Affects Versions: 9.0
> Reporter: Anu Saji
>
> 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.
> =========================================================================
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 11 months
[JBoss JIRA] (TEIIDDES-2850) Import in the Teiid Designer shows incorrect metadata for same tables exist in multiple schemas
by Anu Saji (JIRA)
Anu Saji created TEIIDDES-2850:
----------------------------------
Summary: 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: Feature Request
Components: Import/Export
Affects Versions: 9.0
Reporter: Anu Saji
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.
=========================================================================
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 11 months