Import DDL to Relational Table misses columns for primary, foreign keys
-----------------------------------------------------------------------
Key: TEIIDDES-550
URL:
https://jira.jboss.org/browse/TEIIDDES-550
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1
Environment: Fedora 12, JBDS 3.0.1, TeiidDesigner 7.1 M1
Reporter: Paul Nittel
Attachments: motels.ddl
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira