Details
-
Technical task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
None
Description
--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' |