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

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

XMLWordPrintable

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

      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.

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

              Created:
              Updated:
              Resolved: