Some foreign keys are not shown [message #570139] |
Tue, 24 January 2006 14:44 |
Johannes Lebek Messages: 1 Registered: July 2009 |
Junior Member |
|
|
Hi there,
I have noticed that some foreign key relations are not shown in the
"Data Source Explorer" view (M3, Jan 20). The missing foreign key
relations refer to UNIQUE columns that are no primary key columns.
Example:
CREATE TABLE TAB1 (
COL1 INTEGER NOT NULL,
COL2 INTEGER NOT NULL,
CONSTRAINT PK1 PRIMARY KEY (COL1),
CONSTRAINT UK1 UNIQUE (COL2)
);
CREATE TABLE TAB2 (
COL3 INTEGER,
COL4 INTEGER,
CONSTRAINT FK1 FOREIGN KEY (COL3) REFERENCES TAB1 (COL1),
CONSTRAINT FK2 FOREIGN KEY (COL4) REFERENCES TAB1 (COL2)
);
"FK1" is shown in the explorer view, while "FK2" is missing.
I noticed that the method DatabaseMetaData.getImportedKeys(), which
would return both foreign key relations, is never called in the source
code of M3 that I downloaded.
I have opened a bug report (125003) for this issue. (I know, that it may
be the wrong order to do this: opening a bug report first and asking the
newsgroup thereafter...)
Do you also think it is a bug, or are you saying "Data Source Explorer"
works as designed?
Regards,
Johannes Lebek
|
|
|
Powered by
FUDForum. Page generated in 0.02894 seconds