--source include/have_innodb.inc --source include/have_binlog_format_row.inc reset master; CREATE TABLE t1 ( id INT, k INT, c CHAR(8), KEY (k), PRIMARY KEY (id), FOREIGN KEY (id) REFERENCES t1 (k) ) ENGINE=InnoDB; LOCK TABLES t1 WRITE; SET SESSION FOREIGN_KEY_CHECKS= OFF; SET AUTOCOMMIT=OFF; INSERT INTO t1 VALUES (1,1,'foo'); DROP TABLE t1; SET SESSION FOREIGN_KEY_CHECKS= ON; SET AUTOCOMMIT=ON; source include/show_binlog_events.inc;