Debian Codegraph @

mysql-test/suite/innodb/r/log_alter_table.result

raw
1 #
2 # Bug#21801423 INNODB REDO LOG DOES NOT INDICATE WHEN
3 # FILES ARE CREATED
4 #
5 # Bug#21796691 INNODB REDO LOG DOES NOT INDICATE WHEN
6 # REDO LOGGING IS SKIPPED
7 #
8 SET GLOBAL innodb_checkpoint_disabled=1;
9 CREATE TABLE t1 (a INT NOT NULL, b INT UNIQUE) ENGINE=InnoDB TABLESPACE=innodb_file_per_table;
10 INSERT INTO t1 VALUES (1,2);
11 ALTER TABLE t1 ADD PRIMARY KEY(a), ALGORITHM=INPLACE;
12 ALTER TABLE t1 DROP INDEX b, ADD INDEX (b);
13 # Kill the server
14 # restart: --debug=d,ib_log
15 Pattern "scan .*:.*log rec MLOG_FILE_CREATE.*page .*:0" found
16 Pattern "scan .*:.*log rec MLOG_INDEX_LOAD" found
17 CHECK TABLE t1;
18 Table Op Msg_type Msg_text
19 test.t1 check status OK
20 # restart;
21 DROP TABLE t1;