1# 2# Bug#69122 - INNODB DOESN'T REDO-LOG INSERT BUFFER MERGE 3# OPERATION IF IT IS DONE IN-PLACE 4# 5CREATE TABLE t1( 6a INT AUTO_INCREMENT PRIMARY KEY, 7b CHAR(1), 8c INT, 9INDEX(b)) 10ENGINE=InnoDB STATS_PERSISTENT=0; 11SET GLOBAL innodb_change_buffering_debug = 1; 12INSERT INTO t1 VALUES(0,'x',1); 13INSERT INTO t1 SELECT 0,b,c FROM t1; 14INSERT INTO t1 SELECT 0,b,c FROM t1; 15INSERT INTO t1 SELECT 0,b,c FROM t1; 16INSERT INTO t1 SELECT 0,b,c FROM t1; 17INSERT INTO t1 SELECT 0,b,c FROM t1; 18INSERT INTO t1 SELECT 0,b,c FROM t1; 19INSERT INTO t1 SELECT 0,b,c FROM t1; 20INSERT INTO t1 SELECT 0,b,c FROM t1; 21INSERT INTO t1 SELECT 0,b,c FROM t1; 22INSERT INTO t1 SELECT 0,b,c FROM t1; 23INSERT INTO t1 SELECT 0,b,c FROM t1; 24INSERT INTO t1 SELECT 0,b,c FROM t1; 25INSERT INTO t1 SELECT 0,b,c FROM t1; 26BEGIN; 27SELECT b FROM t1 LIMIT 3; 28b 29x 30x 31x 32BEGIN; 33DELETE FROM t1 WHERE a=1; 34INSERT INTO t1 VALUES(1,'X',1); 35SET DEBUG='+d,crash_after_log_ibuf_upd_inplace'; 36SELECT b FROM t1 LIMIT 3; 37ERROR HY000: Lost connection to MySQL server during query 38CHECK TABLE t1; 39Table Op Msg_type Msg_text 40test.t1 check status OK 41DROP TABLE t1; 42