cubrid icon indicating copy to clipboard operation
cubrid copied to clipboard

[CBRD-24429] Not allowed multiple foreign keys on a column attribute

Open beyondykk9 opened this issue 3 years ago • 0 comments

http://jira.cubrid.org/browse/CBRD-24429

The foreign should be defined only one on a key column, however, the query parser allow the multiple foreign keys on the same column attributes.

CREATE TABLE a_tbl (
        id INT NOT NULL DEFAULT 0 PRIMARY KEY,
        phone VARCHAR(10)
);

CREATE TABLE b_tbl (
        id INT NOT NULL, name VARCHAR (10) NOT NULL,
        CONSTRAINT pk_id PRIMARY KEY (id),
        CONSTRAINT fk_id FOREIGN KEY (id) REFERENCES a_tbl (id)
);
alter table b_tbl add CONSTRAINT fk_id_2 FOREIGN KEY (id) REFERENCES a_tbl (id) ON DELETE CASCADE ON UPDATE RESTRICT;
alter table b_tbl add CONSTRAINT fk_id_3 FOREIGN KEY (id) REFERENCES a_tbl (id);
alter table b_tbl add CONSTRAINT fk_id_4 FOREIGN KEY (id) REFERENCES a_tbl (id) on delete no action;

The above "ALTER TABLE" statments should be failed.

beyondykk9 avatar Jul 19 '22 04:07 beyondykk9