diff options
Diffstat (limited to 'mysql-test/suite/binlog/r/binlog_drop_if_exists.result')
-rw-r--r-- | mysql-test/suite/binlog/r/binlog_drop_if_exists.result | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/mysql-test/suite/binlog/r/binlog_drop_if_exists.result b/mysql-test/suite/binlog/r/binlog_drop_if_exists.result index 4cb5ef32fdd..aa2abd188be 100644 --- a/mysql-test/suite/binlog/r/binlog_drop_if_exists.result +++ b/mysql-test/suite/binlog/r/binlog_drop_if_exists.result @@ -164,3 +164,47 @@ master-bin.000001 # Gtid # # GTID #-#-# master-bin.000001 # Query # # use `test`; CREATE TABLE t1(id int) master-bin.000001 # Gtid # # GTID #-#-# master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS /* */ `t1` /* generated by server */ +# +# MDEV-22820 Bogus "Unknown table" warnings produced upon attempt to +# drop parent table referenced by FK +# +create table t1 (a int, key(a)) engine=InnoDB; +create table t2 (b int, foreign key(b) references t1(a)) engine=InnoDB; +drop table if exists t1; +ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails +drop table if exists t1,t0; +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 +Note 1051 Unknown table 'test.t0' +drop table t2,t1; +create table t3 (a int) engine=aria; +drop table t10,t20; +ERROR 42S02: Unknown table 'test.t10,test.t20' +drop table t10,t20,t3; +ERROR 42S02: Unknown table 'test.t10,test.t20' +drop table if exists t10,t20; +Warnings: +Note 1051 Unknown table 'test.t10,test.t20' +drop table if exists t10,t20,t3; +Warnings: +Note 1051 Unknown table 'test.t10,test.t20,test.t3' +include/show_binlog_events.inc +Log_name Pos Event_type Server_id End_log_pos Info +master-bin.000001 # Gtid # # GTID #-#-# +master-bin.000001 # Query # # use `test`; create table t1 (a int, key(a)) engine=InnoDB +master-bin.000001 # Gtid # # GTID #-#-# +master-bin.000001 # Query # # use `test`; create table t2 (b int, foreign key(b) references t1(a)) engine=InnoDB +master-bin.000001 # Gtid # # GTID #-#-# +master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `t0` /* generated by server */ +master-bin.000001 # Gtid # # GTID #-#-# +master-bin.000001 # Query # # use `test`; DROP TABLE `t2`,`t1` /* generated by server */ +master-bin.000001 # Gtid # # GTID #-#-# +master-bin.000001 # Query # # use `test`; create table t3 (a int) engine=aria +master-bin.000001 # Gtid # # GTID #-#-# +master-bin.000001 # Query # # use `test`; DROP TABLE `t10`,`t20`,`t3` /* generated by server */ +master-bin.000001 # Gtid # # GTID #-#-# +master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `t10`,`t20` /* generated by server */ +master-bin.000001 # Gtid # # GTID #-#-# +master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `t10`,`t20`,`t3` /* generated by server */ |