Debian Codegraph @

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

raw
1 RESET MASTER;
2 connection default;
3 CREATE TABLE t1(id INT AUTO_INCREMENT PRIMARY KEY, a INT, b INT) ENGINE=INNODB;
4 INSERT INTO t1(a, b) VALUES(1,2),(2,4),(3,6),(4,8),(5,10);
5 SET DEBUG_SYNC = "open_and_process_table signal truncate_before_lock wait_for forever";
6 TRUNCATE t1;
7 connect con1,localhost,root,,;
8 SET DEBUG_SYNC = "now wait_for truncate_before_lock";
9 SELECT ((@id := id) - id) FROM information_schema.processlist WHERE processlist.info LIKE '%TRUNCATE t1%' AND state LIKE '%open_and_process_table%';
10 ((@id := id) - id)
11 0
12 KILL QUERY @id;
13 connection default;
14 ERROR 70100: Query execution was interrupted
15 connection con1;
16 include/show_binlog_events.inc
17 Log_name Pos Event_type Server_id End_log_pos Info
18 master-bin.000001 # Gtid # # GTID #-#-#
19 master-bin.000001 # Query # # use `test`; CREATE TABLE t1(id INT AUTO_INCREMENT PRIMARY KEY, a INT, b INT) ENGINE=INNODB
20 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
21 master-bin.000001 # Intvar # # INSERT_ID=1
22 master-bin.000001 # Query # # use `test`; INSERT INTO t1(a, b) VALUES(1,2),(2,4),(3,6),(4,8),(5,10)
23 master-bin.000001 # Xid # # COMMIT /* XID */
24 disconnect con1;
25 connection default;
26 SELECT * FROM t1;
27 id a b
28 1 1 2
29 2 2 4
30 3 3 6
31 4 4 8
32 5 5 10
33 DROP TABLE t1;
34 SET DEBUG_SYNC= 'RESET';