Debian Codegraph @

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

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