Debian Codegraph @

mysql-test/suite/innodb/t/cascade_lock_wait.test

raw
1 --source include/have_debug.inc
2
3 create table t1 (f1 int primary key) engine=innodb;
4 create table t2 (f1 int primary key,
5 constraint c1 foreign key (f1) references t1(f1)
6 on update cascade
7 on delete cascade) engine=innodb;
8 create table t3 (f1 int primary key,
9 constraint c2 foreign key (f1) references t1(f1)
10 on update cascade
11 on delete cascade) engine=innodb;
12 show create table t1;
13 show create table t2;
14 show create table t3;
15
16 insert into t1 values (1);
17 insert into t1 values (2);
18 insert into t1 values (3);
19
20 insert into t2 values (1);
21 insert into t2 values (2);
22 insert into t2 values (3);
23
24 insert into t3 values (1);
25 insert into t3 values (2);
26 insert into t3 values (3);
27
28 select f1 from t1;
29 select f1 from t2;
30 select f1 from t3;
31
32 SET DEBUG='+d,dml_cascade_only_once';
33 SET DEBUG='+d,row_upd_cascade_lock_wait_err';
34 update t1 set f1 = 100 where f1 = 2;
35
36 select f1 from t1;
37 select f1 from t2;
38 select f1 from t3;
39
40 drop table t2;
41 drop table t3;
42 drop table t1;