Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2922

Extra unique constraint in dynamic vdb schema

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.8
    • 8.4
    • AdminApi
    • None
    • Hide

      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);

      Show
      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);

    Description

      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.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            mdrillin1@redhat.com Mark Drilling (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: