Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: CMT1.5.5
-
Fix Version/s: CMT8.4.1.201205
-
Component/s: CUBRID Migration Toolkit
-
Labels:None
-
Environment:
CMT1.5.5.4336
Description
1 Create tables in oracle
create table FKud( id nchar(10));
create table FKmain( id nchar(10));
alter table FKmain add constraint pk_main primary key(id);
alter table fkud add constraint fk_fkud_fkmain foreign key(id) references fkmain(id) on delete cascade;
create table fksn (id nchar(10));
create table fksnmain (id nchar(10));
alter table fksnmain add constraint pk_fksnmain primary key(id);
alter table fksn add constraint fk_fsn_fsn foreign key(id) references fksnmain(id) on delete set null;
create table fkno(id nchar(10));
create table fknomain(id nchar(10));
alter table fknomain add constraint pk_fknomain primary key(id);
alter table fkno add constraint fk_fkno_fknomain foreign key(id) references fknomain(id);
2 do migration goto step5
The FK of fk_fkud_fkmain display on update cascade, on delete cascade.
The FK of fk_fsn_fsn display on update cascade, on delete no action.
The FK of fk_fkno_fknomain display on update cascade, on delete restrict.
Expect result
The FK of fk_fkud_fkmain display on update no action, on delete cascade.
The FK of fk_fsn_fsn display on update no action, on delete set null.
The FK of fk_fkno_fknomain display on update no action, on delete no action.
fixed