|
--source include/have_innodb.inc
|
|
create table t1 (a int, key(a)) engine=InnoDB;
|
create table t2 (b int, foreign key(b) references t1(a)) engine=InnoDB;
|
--error ER_ROW_IS_REFERENCED_2
|
drop table if exists t1;
|
show warnings;
|
|
# Cleanup
|
drop table t2, t1;
|
Before the change, failed DROP TABLE only produced one relevant error:
|
10.5
|
drop table if exists t1;
|
ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails
|
show warnings;
|
Level Code Message
|
Error 1451 Cannot delete or update a parent row: a foreign key constraint fails
|
With MDEV-11412 as of bb-10.5-monty 645f37e49:
drop table if exists t1;
|
ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails
|
show warnings;
|
Level Code Message
|
Error 1451 Cannot delete or update a parent row: a foreign key constraint fails
|
Warning 1051 Unknown table 'test.t1'
|
Error 1051 Unknown table 'test.t1'
|
|
[MDEV-22820]