2
# BUG#40827 - Killing insert-select to MyISAM can cause table corruption
6
`id1` BIGINT(20) AUTO_INCREMENT,
11
`id1` BIGINT(20) AUTO_INCREMENT,
14
INSERT INTO t2 (id) VALUES (123);
15
INSERT INTO t2 (id) SELECT id FROM t2;
16
INSERT INTO t2 (id) SELECT id FROM t2;
17
INSERT INTO t2 (id) SELECT id FROM t2;
18
INSERT INTO t2 (id) SELECT id FROM t2;
19
INSERT INTO t2 (id) SELECT id FROM t2;
20
INSERT INTO t2 (id) SELECT id FROM t2;
21
INSERT INTO t2 (id) SELECT id FROM t2;
22
INSERT INTO t2 (id) SELECT id FROM t2;
23
INSERT INTO t2 (id) SELECT id FROM t2;
24
INSERT INTO t2 (id) SELECT id FROM t2;
25
# Switch to insert Connection
26
SET SESSION debug='+d,wait_in_enable_indexes';
28
INSERT INTO t1(id) SELECT id FROM t2;
29
# Switch to default Connection
30
# Wait for insert data to reach the debug point
31
SELECT ID FROM INFORMATION_SCHEMA.PROCESSLIST
32
WHERE STATE = 'wait_in_enable_indexes' AND
33
INFO = "INSERT INTO t1(id) SELECT id FROM t2"
35
KILL QUERY @thread_id;
37
Table Op Msg_type Msg_text
38
test.t1 check status OK