Debian Codegraph @

mysql-test/suite/innodb/r/innodb-change-buffer-recovery.result

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