[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2614) Add option to remove redundant Unique Constraint in DDL importing if column ID's match a PK

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