]
Barry LaFond updated TEIIDDES-2614:
-----------------------------------
Fix Version/s: 9.0.4
Add option to remove redundant Unique Constraint in DDL importing if
column ID's match a PK
-------------------------------------------------------------------------------------------
Key: TEIIDDES-2614
URL:
https://issues.jboss.org/browse/TEIIDDES-2614
Project: Teiid Designer
Issue Type: Enhancement
Reporter: Barry LaFond
Assignee: Barry LaFond
Fix For: 9.2, 9.0.4
Attachments: TeiidDdlImporter.patch
Teiid Connection importer will return all PK/UC definitions exposed by the DB. Some
DB's auto-create a unique constraint for an defined PK, which is really redundant.
Teiid Designer has a validation check that looks for PK/UC who share common column
ID's and generates an error. This prevents a lot of DDL to end up being imported with
errors.
Suggest looking for this use-case in the Teiid DDL Importer logic and removing the
redundant UC prior to generating the XMI model