mysql-test/suite/binlog/t/foreign_key.test
raw| 1 | --source include/have_innodb.inc |
| 2 | --source include/have_binlog_format_row.inc |
| 3 | |
| 4 | reset master; |
| 5 | |
| 6 | CREATE TABLE t1 ( |
| 7 | id INT, |
| 8 | k INT, |
| 9 | c CHAR(8), |
| 10 | KEY (k), |
| 11 | PRIMARY KEY (id), |
| 12 | FOREIGN KEY (id) REFERENCES t1 (k) |
| 13 | ) ENGINE=InnoDB; |
| 14 | LOCK TABLES t1 WRITE; |
| 15 | SET SESSION FOREIGN_KEY_CHECKS= OFF; |
| 16 | SET AUTOCOMMIT=OFF; |
| 17 | INSERT INTO t1 VALUES (1,1,'foo'); |
| 18 | DROP TABLE t1; |
| 19 | SET SESSION FOREIGN_KEY_CHECKS= ON; |
| 20 | SET AUTOCOMMIT=ON; |
| 21 | |
| 22 | source include/show_binlog_events.inc; |