Debian Codegraph @

mysql-test/suite/rpl/r/rpl_drop_db_fail.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 CREATE DATABASE IF NOT EXISTS db1;
5 CREATE DATABASE IF NOT EXISTS db2;
6 use db1;
7 CREATE TABLE a(id INT);
8 CREATE VIEW v AS SELECT * FROM a;
9 CREATE TABLE table_father(id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(20)) ENGINE=INNODB;
10 connection slave;
11 connection master;
12 use db2;
13 CREATE TABLE table_child(id INT PRIMARY KEY, info VARCHAR(20), father_id INT) ENGINE=INNODB;
14 ALTER TABLE table_child ADD CONSTRAINT aaa FOREIGN KEY (father_id) REFERENCES db1.table_father(id);
15 DROP DATABASE db1;
16 ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails
17 DROP DATABASE db2;
18 connection slave;
19 connection master;
20 DROP DATABASE db1;
21 include/rpl_end.inc