1) Create a table in MySQL DB using this DDL -
CREATE TABLE PricesTable ( ProdCode CHAR(40) NOT NULL, SalePrice DECIMAL(), PRIMARY KEY ProdCode );
2) Create a DS for the MySQL DB. (I'm using Teiid Connection Importer in Designer).
3) Deploy Dynamic VDB. In connection importer - the returned DDL looks like this:
CREATE FOREIGN TABLE "temp2.PricesTable" ( ProdCode string(40) NOT NULL OPTIONS (ANNOTATION '', NAMEINSOURCE '`ProdCode`', NATIVE_TYPE 'CHAR'), SalePrice bigdecimal(10,2147483647) OPTIONS (ANNOTATION '', NAMEINSOURCE '`SalePrice`', NATIVE_TYPE 'DECIMAL'), CONSTRAINT "PRIMARY" PRIMARY KEY(ProdCode), CONSTRAINT "PRIMARY" UNIQUE(ProdCode) ) OPTIONS (ANNOTATION '', NAMEINSOURCE '`temp2`.`PricesTable`', UPDATABLE TRUE);
I'm getting an extra Unique Constraint in the dynamic VDB schema - for a MySQL table with only a primary key. See steps to reproduce.