refactions2.out

derby database source code.good for you.

0 rows inserted/updated/deleted
ij> create table t2(x int, y int not null unique, z int);
0 rows inserted/updated/deleted
ij> create table t3(l int, m int not null unique , k int );
0 rows inserted/updated/deleted
ij> create table t4(c1 int not null unique , c2 int);
0 rows inserted/updated/deleted
ij> -- error scenario 1: adding constraint c4 will make t2 get two paths from t1 with SET NULLS
alter table t2 add constraint c1 foreign key (x)
                              references t1(a) on delete set null;
0 rows inserted/updated/deleted
ij> alter table t2 add constraint c2 foreign key (z)
                              references t4(c1) on delete set null;
0 rows inserted/updated/deleted
ij> alter table t3 add constraint c3 foreign key (l)
                              references t1(a) on delete cascade;
0 rows inserted/updated/deleted
ij> alter table t4 add constraint c4 foreign key (c1)
                              references t3(m) on delete cascade;
ERROR 42915: Foreign  Key 'C4' is invalid because 'the delete rule of foreign key can not be CASCADE. (The relationship would cause another table to be delete-connected to the same table through multiple paths with different delete rules or with delete rule equal to SET NULL.) '. 
ij> alter table t2 drop constraint c1;
0 rows inserted/updated/deleted
ij> alter table t2 drop constraint c2;
0 rows inserted/updated/deleted
ij> alter table t3 drop constraint c3;
0 rows inserted/updated/deleted
ij> -- error scenario 2: adding constraint c4 will make t2 get two paths from t1 with a SET NULL and
--- a CASCADE.
alter table t2 add constraint c1 foreign key (x)
                              references t1(a) on delete CASCADE;
0 rows inserted/updated/deleted
ij> alter table t2 add constraint c2 foreign key (z)
                              references t4(c1) on delete set null;
0 rows inserted/updated/deleted
ij> alter table t3 add constraint c3 foreign key (l)
                              references t1(a) on delete cascade;
0 rows inserted/updated/deleted
ij> alter table t4 add constraint c4 foreign key (c1)
                              references t3(m) on delete cascade;
ERROR 42915: Foreign  Key 'C4' is invalid because 'the delete rule of foreign key can not be CASCADE. (The relationship would cause another table to be delete-connected to the same table through multiple paths with different delete rules or with delete rule equal to SET NULL.) '. 
ij> alter table t2 drop constraint c1;
0 rows inserted/updated/deleted
ij> alter table t2 drop constraint c2;
0 rows inserted/updated/deleted
ij> alter table t3 drop constraint c3;
0 rows inserted/updated/deleted
ij> -- error scenario 3: adding constraint c4 will make t2 get two paths from t1 with a NO ACTION 
--- and a CASCADE.
alter table t2 add constraint c1 foreign key (x)
                              references t1(a) on delete NO ACTION;
0 rows inserted/updated/deleted
ij> alter table t2 add constraint c2 foreign key (z)
                              references t4(c1) on delete set null;
0 rows inserted/updated/deleted
ij> alter table t3 add constraint c3 foreign key (l)
                              references t1(a) on delete cascade;
0 rows inserted/updated/deleted
ij> alter table t4 add constraint c4 foreign key (c1)
                              references t3(m) on delete cascade;
ERROR 42915: Foreign  Key 'C4' is invalid because 'the delete rule of foreign key can not be CASCADE. (The relationship would cause another table to be delete-connected to the same table through multiple paths with different delete rules or with delete rule equal to SET NULL.) '. 
ij> alter table t2 drop constraint c1;
0 rows inserted/updated/deleted
ij> alter table t2 drop constraint c2;
0 rows inserted/updated/deleted
ij> alter table t3 drop constraint c3;
0 rows inserted/updated/deleted
ij> -- error scenario 4: adding constraint c4 will make t2 get two paths from t1 with a CASCADE
--- and a RESTRICT.
alter table t2 add constraint c1 foreign key (x)
                              references t1(a) on delete CASCADE;
0 rows inserted/updated/deleted
ij> alter table t2 add constraint c2 foreign key (z)
                              references t4(c1) on delete RESTRICT;
0 rows inserted/updated/deleted
ij> alter table t3 add constraint c3 foreign key (l)
                              references t1(a) on delete cascade;
0 rows inserted/updated/deleted
ij> alter table t4 add constraint c4 foreign key (c1)
                              references t3(m) on delete cascade;
ERROR 42915: Foreign  Key 'C4' is invalid because 'the delete rule of foreign key can not be CASCADE. (The relationship would cause another table to be delete-connected to the same table through multiple paths with different delete rules or with delete rule equal to SET NULL.) '. 
ij> alter table t2 drop constraint c1;
0 rows inserted/updated/deleted
ij> alter table t2 drop constraint c2;
0 rows inserted/updated/deleted
ij> alter table t3 drop constraint c3;
0 rows inserted/updated/deleted
ij> --FOLLOWING SHOULD PASS
alter table t2 add constraint c1 foreign key (x)
                              references t1(a) on delete set null;
0 rows inserted/updated/deleted
ij> alter table t2 add constraint c2 foreign key (z)
                              references t4(c1) on delete set null;
0 rows inserted/updated/deleted
ij> alter table t3 add constraint c3 foreign key (l)
                              references t1(a) on delete set null;
0 rows inserted/updated/deleted
ij> alter table t4 add constraint c4 foreign key (c1)
                              references t3(m) on delete cascade;
0 rows inserted/updated/deleted
ij> alter table t2 drop constraint c1;
0 rows inserted/updated/deleted
ij> alter table t2 drop constraint c2;
0 rows inserted/updated/deleted
ij> alter table t3 drop constraint c3;
0 rows inserted/updated/deleted
ij> alter table t4 drop constraint c4;
0 rows inserted/updated/deleted
ij> alter table t2 add constraint c1 foreign key (x)
                              references t1(a) on delete CASCADE;
0 rows inserted/updated/deleted
ij> alter table t2 add constraint c2 foreign key (z)
                              references t4(c1) on delete set null;
0 rows inserted/updated/deleted
ij> alter table t3 add constraint c3 foreign key (l)
                              references t1(a) on delete set null;
0 rows inserted/updated/deleted
ij> alter table t4 add constraint c4 foreign key (c1)
                              references t3(m) on delete cascade;
0 rows inserted/updated/deleted
ij> alter table t2 drop constraint c1;
0 rows inserted/updated/deleted
ij> alter table t2 drop constraint c2;
0 rows inserted/updated/deleted
ij> alter table t3 drop constraint c3;
0 rows inserted/updated/deleted
ij> alter table t4 drop constraint c4;
0 rows inserted/updated/deleted
ij> alter table t2 add constraint c1 foreign key (x)
                              references t1(a) on delete CASCADE;
0 rows inserted/updated/deleted
ij> alter table t2 add constraint c2 foreign key (z)
                              references t4(c1) on delete CASCADE;
0 rows inserted/updated/deleted
ij> alter table t3 add constraint c3 foreign key (l)
                              references t1(a) on delete set null;
0 rows inserted/updated/deleted
ij> alter table t4 add constraint c4 foreign key (c1)
                              references t3(m) on delete cascade;
0 rows inserted/updated/deleted
ij> alter table t2 drop constraint c1;
0 rows inserted/updated/deleted
ij> alter table t2 drop constraint c2;
0 rows inserted/updated/deleted
ij> alter table t3 drop constraint c3;
0 rows inserted/updated/deleted
ij> alter table t4 drop constraint c4;
0 rows inserted/updated/deleted
ij> alter table t2 add constraint c1 foreign key (x)
                              references t1(a) on delete CASCADE;
0 rows inserted/updated/deleted
ij> alter table t2 add constraint c2 foreign key (z)
                              references t4(c1) on delete CASCADE;
0 rows inserted/updated/deleted
ij> alter table t3 add constraint c3 foreign key (l)
                              references t1(a) on delete CASCADE;
0 rows inserted/updated/deleted
ij> alter table t4 add constraint c4 foreign key (c1)
                              references t3(m) on delete cascade;
0 rows inserted/updated/deleted
ij> alter table t2 drop constraint c1;
0 rows inserted/updated/deleted
ij> alter table t2 drop constraint c2;
0 rows inserted/updated/deleted
ij> alter table t3 drop constraint c3;
0 rows inserted/updated/deleted
ij> alter table t4 drop constraint c4;
0 rows inserted/updated/deleted
ij> alter table t2 add constraint c1 foreign key (x)
                              references t1(a) on delete SET NULL;
0 rows inserted/updated/deleted
ij> alter table t2 add constraint c2 foreign key (z)
                              references t4(c1) on delete SET NULL;
0 rows inserted/updated/deleted
ij> alter table t3 add constraint c3 foreign key (l)
                              references t1(a) on delete SET NULL;
0 rows inserted/updated/deleted
ij> alter table t4 add constraint c4 foreign key (c1)
                              references t3(m) on delete RESTRICT;
0 rows inserted/updated/deleted
ij> alter table t2 drop constraint c1;
0 rows inserted/updated/deleted
ij> alter table t2 drop constraint c2;
0 rows inserted/updated/deleted
ij> alter table t3 drop constraint c3;
0 rows inserted/updated/deleted
ij> alter table t4 drop constraint c4;
0 rows inserted/updated/deleted
ij> alter table t2 add constraint c1 foreign key (x)
                              references t1(a) on delete SET NULL;
0 rows inserted/updated/deleted
ij> alter table t2 add constraint c2 foreign key (z)
                              references t4(c1) on delete SET NULL;
0 rows inserted/updated/deleted
ij> alter table t3 add constraint c3 foreign key (l)
                              references t1(a) on delete CASCADE;
0 rows inserted/updated/deleted
ij> alter table t4 add constraint c4 foreign key (c1)
                              references t3(m) on delete RESTRICT;
0 rows inserted/updated/deleted
ij> alter table t2 drop constraint c1;
0 rows inserted/updated/deleted
ij> alter table t2 drop constraint c2;
0 rows inserted/updated/deleted
ij> alter table t3 drop constraint c3;
0 rows inserted/updated/deleted
ij> alter table t4 drop constraint c4;
0 rows inserted/updated/deleted
ij> alter table t2 add constraint c1 foreign key (x)
                              references t1(a) on delete SET NULL;
0 rows inserted/updated/deleted
ij> alter table t2 add constraint c2 foreign key (z)
                              references t4(c1) on delete CASCADE;
0 rows inserted/updated/deleted
ij> alter table t3 add constraint c3 foreign key (l)
                              references t1(a) on delete CASCADE;
0 rows inserted/updated/deleted
ij> alter table t4 add constraint c4 foreign key (c1)
                              references t3(m) on delete RESTRICT;
0 rows inserted/updated/deleted
ij> alter table t2 drop constraint c1;
0 rows inserted/updated/deleted
ij> alter table t2 drop constraint c2;
0 rows inserted/updated/deleted
ij> alter table t3 drop constraint c3;
0 rows inserted/updated/deleted
ij> alter table t4 drop constraint c4;
0 rows inserted/updated/deleted
ij> drop table t1;
0 rows inserted/updated/deleted
ij> drop table t2;
0 rows inserted/updated/deleted
ij> drop table t3;