Debian Codegraph @

mysql-test/suite/rpl/t/rpl_drop_db_fail.test

raw
1 ###############################################################################
2 # Bug#20041860: SLAVE ERROR WHEN DROP DATABASE
3 #
4 # Test:
5 # =====
6 # Create two databases such that one database has a dependency over the other
7 # database and try to drop the database which has a dependency. This should
8 # not cause slave to break.
9 ###############################################################################
10 --source include/have_innodb.inc
11 --source include/master-slave.inc
12
13 connection master;
14 CREATE DATABASE IF NOT EXISTS db1;
15 CREATE DATABASE IF NOT EXISTS db2;
16
17 use db1;
18 CREATE TABLE a(id INT);
19 CREATE VIEW v AS SELECT * FROM a;
20 CREATE TABLE table_father(id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(20)) ENGINE=INNODB;
21 --sync_slave_with_master
22
23 connection master;
24 use db2;
25 CREATE TABLE table_child(id INT PRIMARY KEY, info VARCHAR(20), father_id INT) ENGINE=INNODB;
26 ALTER TABLE table_child ADD CONSTRAINT aaa FOREIGN KEY (father_id) REFERENCES db1.table_father(id);
27
28 --error ER_ROW_IS_REFERENCED_2
29 DROP DATABASE db1;
30 DROP DATABASE db2;
31 --sync_slave_with_master
32 --connection master
33 DROP DATABASE db1;
34 --source include/rpl_end.inc