Debian Codegraph @

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

raw
1 --source include/have_debug_sync.inc
2
3 --echo #
4 --echo # Bug #20476395 DICT_LOAD_FOREIGNS() FAILED IN
5 --echo # COMMIT_INPLACE_ALTER_TABLE
6 --echo #
7
8 call mtr.add_suppression("Failed to load table");
9
10 create database bug;
11 use bug;
12
13 create table parent(a serial) engine=innodb;
14 create table child(a serial, foreign key fk (a) references parent(a));
15
16 insert into parent values(1);
17 insert into child values(1);
18
19 connect (con1,localhost,root,,bug);
20 SET DEBUG_SYNC='innodb_rename_table_ready SIGNAL s1 WAIT_FOR s2 EXECUTE 2';
21 --send ALTER TABLE child ROW_FORMAT=DYNAMIC, ALGORITHM=COPY
22 connection default;
23 SET DEBUG_SYNC='now WAIT_FOR s1';
24 SET DEBUG_SYNC='now SIGNAL s2 WAIT_FOR s1';
25 --source include/kill_and_restart_mysqld.inc
26 disconnect con1;
27
28 show tables;
29 alter table parent row_format=dynamic;
30
31 drop table child;
32 drop table parent;
33 drop database bug;