Edit File: rpl_drop_db_fail.result
include/master-slave.inc [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; 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; DROP DATABASE db1; include/rpl_end.inc
Back to File Manager