Debian Codegraph @

mysql-test/suite/binlog/r/foreign_key.result

raw
1 reset master;
2 CREATE TABLE t1 (
3 id INT,
4 k INT,
5 c CHAR(8),
6 KEY (k),
7 PRIMARY KEY (id),
8 FOREIGN KEY (id) REFERENCES t1 (k)
9 ) ENGINE=InnoDB;
10 LOCK TABLES t1 WRITE;
11 SET SESSION FOREIGN_KEY_CHECKS= OFF;
12 SET AUTOCOMMIT=OFF;
13 INSERT INTO t1 VALUES (1,1,'foo');
14 DROP TABLE t1;
15 SET SESSION FOREIGN_KEY_CHECKS= ON;
16 SET AUTOCOMMIT=ON;
17 include/show_binlog_events.inc
18 Log_name Pos Event_type Server_id End_log_pos Info
19 master-bin.000001 # Gtid # # GTID #-#-#
20 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (
21 id INT,
22 k INT,
23 c CHAR(8),
24 KEY (k),
25 PRIMARY KEY (id),
26 FOREIGN KEY (id) REFERENCES t1 (k)
27 ) ENGINE=InnoDB
28 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
29 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1,1,'foo')
30 master-bin.000001 # Table_map # # table_id: # (test.t1)
31 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
32 master-bin.000001 # Xid # # COMMIT /* XID */
33 master-bin.000001 # Gtid # # GTID #-#-#
34 master-bin.000001 # Query # # use `test`; set foreign_key_checks=0; DROP TABLE `t1` /* generated by server */