Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-550

Import DDL to Relational Table misses columns for primary, foreign keys

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.1.1
    • 7.1
    • Import/Export
    • None

    Description

      I imported the motels.ddl example file to populate the foo model. When finished importing, I had a number of errors where the importer had created primary and foreign keys without specifying columns for those keys. In one case, here's the DDL:
      CREATE TABLE CustomerFamilyHistory
      (
      customerfamilyhistoryid number(10) CONSTRAINT customerfamilyhistoryid_pk PRIMARY KEY,
      firstname varchar2(50) NOT NULL,
      lastname varchar2(50) NOT NULL,
      age number(3),
      sibling varchar2(20),
      customerid number(7) NOT NULL
      );

      The primary key, customerfamilyhistoryid_pk, is created, but no reference to customerfamilyhistoryid is provided.

      Attachments

        Issue Links

          Activity

            People

              dflorian@redhat.com Daniel Florian (Inactive)
              pnittel_jira Paul Nittel (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: