📄 refactions3.out
字号:
C3 CHAR(3), CONSTRAINT FK7 FOREIGN KEY (C0b,C2,C3) REFERENCES refint.E410_T2 ON DELETE CASCADE, CONSTRAINT FK8 FOREIGN KEY (C0a,C1,C2) REFERENCES refint.E410_T3 ON DELETE CASCADE);0 rows inserted/updated/deletedij> CREATE TABLE refint.E450_T1 (C1 CHAR(3) NOT NULL, C0 CHAR(3) NOT NULL, PRIMARY KEY (C0,C1));0 rows inserted/updated/deletedij> CREATE TABLE refint.E450_T2 (C1 CHAR(3) NOT NULL, C0 CHAR(3) NOT NULL, C2 CHAR(3) NOT NULL, C0c CHAR(3), C3 CHAR(3), PRIMARY KEY (C0,C1,C2), CONSTRAINT FK20 FOREIGN KEY (C0c,C3) REFERENCES refint.E450_T1 ON DELETE SET NULL);0 rows inserted/updated/deletedij> CREATE TABLE refint.E450_T3 (C0 CHAR(3) NOT NULL, C1 CHAR(3) NOT NULL, C2 CHAR(3) NOT NULL, C0c CHAR(3), C3 CHAR(3), PRIMARY KEY (C0,C1,C2), CONSTRAINT FK38 FOREIGN KEY (C0c,C3) REFERENCES refint.E450_T1 ON DELETE CASCADE);0 rows inserted/updated/deletedij> CREATE TABLE refint.E450_T4 (C1 CHAR(3), C0 CHAR(3), C0a CHAR(3), C0b CHAR(3), C2 CHAR(3), C3 CHAR(3), CONSTRAINT FK3 FOREIGN KEY (C0b,C2,C3) REFERENCES refint.E450_T2 ON DELETE SET NULL, CONSTRAINT FK4 FOREIGN KEY (C0a,C1,C2) REFERENCES refint.E450_T3 ON DELETE CASCADE);0 rows inserted/updated/deletedij> CREATE TABLE refint.E510_T1 (C1 CHAR(3) NOT NULL, C0 CHAR(3) NOT NULL, C0a CHAR(3), C2 CHAR(3), PRIMARY KEY (C0,C1));0 rows inserted/updated/deletedij> CREATE TABLE refint.E510_T2 (C1 CHAR(3) NOT NULL, C0 CHAR(3) NOT NULL, C0b CHAR(3), C2 CHAR(3), PRIMARY KEY (C0,C1), CONSTRAINT FK21 FOREIGN KEY (c0b,C2) REFERENCES refint.E510_T1 ON DELETE SET NULL);0 rows inserted/updated/deletedij> CREATE TABLE refint.E510_T3 (C0 CHAR(3) NOT NULL, C1 CHAR(3) NOT NULL, C2 CHAR(3), C0b CHAR(3), PRIMARY KEY(C0,C1), CONSTRAINT FK39 FOREIGN KEY (C0b,C2) REFERENCES refint.E510_T2 ON DELETE SET NULL);0 rows inserted/updated/deletedij> alter table refint.E510_T1 add CONSTRAINT CYC FOREIGN KEY (C0a,C1) REFERENCES refint.E510_T3 ON DELETE CASCADE;0 rows inserted/updated/deletedij> CREATE VIEW refint.E510_V1 AS SELECT * FROM refint.E510_T3;0 rows inserted/updated/deletedij> CREATE TABLE refint.E540_T1 (C0 CHAR(3) NOT NULL, C0a CHAR(3), C1 CHAR(3) NOT NULL, C2 CHAR(3), PRIMARY KEY (C0,C1));0 rows inserted/updated/deletedij> CREATE TABLE refint.E540_T2 (C1 CHAR(3) NOT NULL, C0 CHAR(3) NOT NULL, C2 CHAR(3), C0b CHAR(3), PRIMARY KEY (C0,C1), CONSTRAINT E540_T1_T2 FOREIGN KEY (C0b,C2) REFERENCES refint.E540_T1 ON DELETE RESTRICT);0 rows inserted/updated/deletedij> CREATE TABLE refint.E540_T3 (C1 CHAR(3) NOT NULL, C0 CHAR(3) NOT NULL, C2 CHAR(3), C0b CHAR(3), PRIMARY KEY (C0,C1), CONSTRAINT E540_T2_T3 FOREIGN KEY (C0b,C2) REFERENCES refint.E540_T2 ON DELETE RESTRICT);0 rows inserted/updated/deletedij> alter table refint.E540_T1 add CONSTRAINT E540_T3_T1 FOREIGN KEY (C0a,C1) REFERENCES refint.E540_T3 ON DELETE RESTRICT;0 rows inserted/updated/deletedij> CREATE TABLE refint.E560_T1 (C1 CHAR(3) NOT NULL, C0a CHAR(3), C0 CHAR(3) NOT NULL, PRIMARY KEY (C0,C1));0 rows inserted/updated/deletedij> CREATE TABLE refint.E560_T2 (C1 CHAR(3) NOT NULL, C0 CHAR(3) NOT NULL, C2 CHAR(3), C0b CHAR(3), PRIMARY KEY (C0,C1), CONSTRAINT E560_T2_T1 FOREIGN KEY (C0b,C2) REFERENCES refint.E560_T1 ON DELETE RESTRICT);0 rows inserted/updated/deletedij> CREATE TABLE refint.E560_T3 (C1 CHAR(3) NOT NULL, C0 CHAR(3) NOT NULL, C2 CHAR(3), C0b CHAR(3), PRIMARY KEY (C0,C1), CONSTRAINT E560_T3_T2 FOREIGN KEY (C0b,C2) REFERENCES refint.E560_T2 ON DELETE RESTRICT);0 rows inserted/updated/deletedij> alter table refint.E560_T1 add CONSTRAINT E560_T1_T3 FOREIGN KEY (C0a,C1) REFERENCES refint.E560_T3 ON DELETE CASCADE;0 rows inserted/updated/deletedij> CREATE TABLE refint.E550_T1 (C0 CHAR(3) NOT NULL, C1 CHAR(3) NOT NULL, C0b CHAR(3), C2 CHAR(3), PRIMARY KEY (C0,C1));0 rows inserted/updated/deletedij> CREATE TABLE refint.E550_T2 (C0 CHAR(3) NOT NULL, C1 CHAR(3) NOT NULL, C0b CHAR(3), C2 CHAR(3), PRIMARY KEY (C0,C1), FOREIGN KEY (C0b,C2) REFERENCES refint.E550_T1 ON DELETE SET NULL);0 rows inserted/updated/deletedij> CREATE TABLE refint.E550_T3 (C1 CHAR(3) NOT NULL, C0 CHAR(3) NOT NULL, C2 CHAR(3), C0b CHAR(3), PRIMARY KEY (C0,C1), FOREIGN KEY (C0b,C2) REFERENCES refint.E550_T2 ON DELETE SET NULL);0 rows inserted/updated/deletedij> alter table refint.E550_T1 add CONSTRAINT F550 FOREIGN KEY (C0b,C2) REFERENCES refint.E550_T3 ON DELETE SET NULL;0 rows inserted/updated/deletedij> CREATE TABLE refint.E570_T1 (C1 CHAR(3) NOT NULL, C0 CHAR(3) NOT NULL, C0a CHAR(3), C2 CHAR(3), PRIMARY KEY (C0,C1));0 rows inserted/updated/deletedij> CREATE TABLE refint.E570_T2 (C1 CHAR(3) NOT NULL, C0 CHAR(3) NOT NULL, C2 CHAR(3), C0b CHAR(3), PRIMARY KEY (C0,C1));0 rows inserted/updated/deletedij> CREATE TABLE refint.E570_T3 (C1 CHAR(3) NOT NULL, C0 CHAR(3) NOT NULL, C2 CHAR(3), C0b CHAR(3), PRIMARY KEY (C0,C1));0 rows inserted/updated/deletedij> alter table refint.E570_T1 add CONSTRAINT E570_T1_T3 FOREIGN KEY (C0a,C1) REFERENCES refint.E570_T3 ON DELETE CASCADE;0 rows inserted/updated/deletedij> alter table refint.E570_T2 add CONSTRAINT E570_T2_T1 FOREIGN KEY (C0b,C2) REFERENCES refint.E570_T1 ON DELETE RESTRICT;0 rows inserted/updated/deletedij> alter table refint.E570_T3 add CONSTRAINT E570_T3_T2 FOREIGN KEY (C0b,C2) REFERENCES refint.E570_T2 ON DELETE SET NULL;0 rows inserted/updated/deletedij> CREATE VIEW refint.E570_V1 AS SELECT * FROM refint.E570_T3;0 rows inserted/updated/deletedij> CREATE TABLE refint.E710_T1 (C1 CHAR(3) NOT NULL, C0 CHAR(3) NOT NULL, C2 CHAR(3), C0b CHAR(3), C3 CHAR(3), C0c CHAR(3), PRIMARY KEY (C0,C1), FOREIGN KEY (C0b,C2) REFERENCES refint.E710_T1 ON DELETE CASCADE, FOREIGN KEY (C0c,C3) REFERENCES refint.E710_T1 ON DELETE CASCADE);0 rows inserted/updated/deletedij> CREATE TABLE refint.E720_T1 (C1 CHAR(3) NOT NULL, C0 CHAR(3) NOT NULL, C2 CHAR(3), C0b CHAR(3), PRIMARY KEY (C0,C1), FOREIGN KEY (C0b,C2) REFERENCES refint.E720_T1 ON DELETE CASCADE);0 rows inserted/updated/deletedij> CREATE TABLE refint.E720_T2 (X1 CHAR(3) NOT NULL, C0 CHAR(3) NOT NULL, X3 CHAR(3), C0d CHAR(3), C3 CHAR(3), C0c CHAR(3), PRIMARY KEY (C0,X1), FOREIGN KEY (C0d,X3) REFERENCES refint.E720_T2 ON DELETE CASCADE, FOREIGN KEY (C0c,C3) REFERENCES refint.E720_T1 ON DELETE CASCADE);0 rows inserted/updated/deletedij> CREATE TABLE refint.E610_T1 (C0 CHAR(3) NOT NULL, P1 CHAR(3) NOT NULL, P2 CHAR(3) NOT NULL, PRIMARY KEY (C0,P1,P2));0 rows inserted/updated/deletedij> CREATE TABLE refint.E610_T2 (P1 CHAR(3), C0 CHAR(3) NOT NULL, P4 CHAR(3) NOT NULL, P5 CHAR(3) NOT NULL, PRIMARY KEY (C0,P4,P5));0 rows inserted/updated/deletedij> CREATE TABLE refint.E610_T3 (F1 CHAR(3), C0 CHAR(3), C0e CHAR(3), F2 CHAR(3), C0g CHAR(3), F3 CHAR(3), CONSTRAINT E610_T1_T3 FOREIGN KEY (C0e,F1,F2) REFERENCES refint.E610_T1, CONSTRAINT E610_T2_T3 FOREIGN KEY (C0g,F2,F3) REFERENCES refint.E610_T2) ;0 rows inserted/updated/deletedij> ---END OF TEST CASES GOT FROM DB2 Tests.--START RANDOM COMPLEX LINKScreate table t1( a int not null primary key, b int);0 rows inserted/updated/deletedij> create table t2(x int, y int not null unique, z int);0 rows inserted/updated/deletedij> create table t3(l int, m int not null unique , k int );0 rows inserted/updated/deletedij> create table t4(c1 int not null unique , c2 int);0 rows inserted/updated/deletedij> create table t5(c1 int not null unique , c2 int);0 rows inserted/updated/deletedij> create table t6(c1 int not null unique , c2 int);0 rows inserted/updated/deletedij> --cyclealter table t2 add constraint c3 foreign key (z) references t4(c1) on delete cascade;0 rows inserted/updated/deletedij> alter table t4 add constraint c4 foreign key (c2) references t5(c1) on delete cascade;0 rows inserted/updated/deletedij> alter table t5 add constraint c5 foreign key (c2) references t6(c1) on delete cascade;0 rows inserted/updated/deletedij> alter table t1 add constraint c1 foreign key (b) references t3(m) on delete cascade;0 rows inserted/updated/deletedij> alter table t2 add constraint c2 foreign key (x) references t1(a) on delete cascade;0 rows inserted/updated/deletedij> alter table t3 add constraint c6 foreign key (k) references t2(y) on delete cascade;0 rows inserted/updated/deletedij> --link a self referencing table to above cycle with a SET NULLcreate table t7( a int not null primary key, b int not null unique, x int references t7(a) ON DELETE CASCADE, z int references t7(b) ON DELETE CASCADE, w int references t6(c1) ON DELETE SET NULL);0 rows inserted/updated/deletedij> --valide multiple pathscreate table t8( a int not null primary key, b int);0 rows inserted/updated/deletedij> create table t9(x int, y int not null unique, z int);0 rows inserted/updated/deletedij> create table t10(l int, m int not null unique , k int );0 rows inserted/updated/deletedij> create table t11(c1 int not null unique , c2 int);0 rows inserted/updated/deletedij> alter table t9 add constraint c7 foreign key (x) references t8(a) on delete set null;0 rows inserted/updated/deletedij> alter table t9 add constraint c8 foreign key (z) references t11(c1) on delete set null;0 rows inserted/updated/deletedij> alter table t10 add constraint c9 foreign key (l) references t8(a) on delete set null;0 rows inserted/updated/deletedij> alter table t11 add constraint c10 foreign key (c1) references t10(m) on delete cascade;0 rows inserted/updated/deletedij> --link this one first cycle casealter table t9 add constraint c11 foreign key (z) references t5(c1) on delete SET NULL;0 rows inserted/updated/deletedij> --valide multiple pathscreate table t12( a int not null primary key, b int);0 rows inserted/updated/deletedij> create table t13(x int, y int not null unique, z int);0 rows inserted/updated/deletedij> create table t14(l int, m int not null unique , k int );0 rows inserted/updated/deletedij> create table t15(c1 int not null unique , c2 int);0 rows inserted/updated/deletedij> alter table t13 add constraint c12 fore⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -