Debian Codegraph @

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;