Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.1
-
None
Description
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-trusty-amd64/builds/11465
rpl.rpl_drop_db_fail 'stmt,xtradb' w3 [ fail ]
|
Test ended at 2018-07-19 19:37:27
|
|
CURRENT_TEST: rpl.rpl_drop_db_fail
|
|
|
Failed to start mysqld.2
|
mysqltest failed but provided no output
|
The result from queries just before the failure was:
|
< snip >
|
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
|