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
    • Fedora 12, JBDS 3.0.1, TeiidDesigner 7.1 M1

      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: