EVOLUTION-MANAGER

Edit File: rpl_drop_db_fail.result

include/master-slave.inc [connection master] connection master; CREATE DATABASE IF NOT EXISTS db1; CREATE DATABASE IF NOT EXISTS db2; use db1; CREATE TABLE a(id INT); CREATE VIEW v AS SELECT * FROM a; CREATE TABLE table_father(id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(20)) ENGINE=INNODB; connection slave; connection master; use db2; CREATE TABLE table_child(id INT PRIMARY KEY, info VARCHAR(20), father_id INT) ENGINE=INNODB; ALTER TABLE table_child ADD CONSTRAINT aaa FOREIGN KEY (father_id) REFERENCES db1.table_father(id); DROP DATABASE db1; ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails DROP DATABASE db2; connection slave; connection master; DROP DATABASE db1; include/rpl_end.inc