1
# Test Bug #57255. Cascade deletes that affect different rows should not
2
# result in DB_FOREIGN_EXCEED_MAX_CASCADE error
4
--source include/have_innodb.inc
6
create table A(id int not null primary key) engine=innodb;
8
create table B(id int not null auto_increment primary key, f1 int not null, foreign key(f1) references A(id) on delete cascade) engine=innodb;
10
create table C(id int not null auto_increment primary key, f1 int not null, foreign key(f1) references B(id) on delete cascade) engine=innodb;
12
insert into A values(1), (2);
19
insert into B(f1) values(1);
25
insert into C(f1) values(2);
31
# Following Deletes should not report error
32
DELETE FROM A where id = 1;
33
DELETE FROM C where f1 = 2;
34
DELETE FROM A where id = 1;