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 Labels: release_notes, verified_jbdsis-8.0.4.CR1 Fix For: 9.0.4, 9.2 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