Debian Codegraph @

mysql-test/suite/innodb/t/log_alter_table.test

raw
1 --source include/have_debug.inc
2
3
4 --echo #
5 --echo # Bug#21801423 INNODB REDO LOG DOES NOT INDICATE WHEN
6 --echo # FILES ARE CREATED
7 --echo #
8 --echo # Bug#21796691 INNODB REDO LOG DOES NOT INDICATE WHEN
9 --echo # REDO LOGGING IS SKIPPED
10 --echo #
11
12 SET GLOBAL innodb_checkpoint_disabled=1;
13
14 --source include/no_checkpoint_start.inc
15 CREATE TABLE t1 (a INT NOT NULL, b INT UNIQUE) ENGINE=InnoDB TABLESPACE=innodb_file_per_table;
16 # MLOG_INDEX_LOAD will not be emitted for empty tables. Insert a row.
17 INSERT INTO t1 VALUES (1,2);
18 # We should get two MLOG_INDEX_LOAD for this.
19 ALTER TABLE t1 ADD PRIMARY KEY(a), ALGORITHM=INPLACE;
20 # And one MLOG_INDEX_LOAD for this.
21 ALTER TABLE t1 DROP INDEX b, ADD INDEX (b);
22
23 --let CLEANUP_IF_CHECKPOINT=DROP TABLE t1;
24 --source include/no_checkpoint_end.inc
25
26 --let $restart_parameters = restart: --debug=d,ib_log
27 --source include/start_mysqld.inc
28
29 let SEARCH_FILE = $MYSQLTEST_VARDIR/log/mysqld.1.err;
30 # Look for at least one MLOG_FILE_CREATE in the error log.
31 # Theoretically, it may have been written by this test or an earlier test.
32 # FIXME: redirect the error log of the restart to a new file,
33 # and ensure that we have exactly 2 records there.
34 let SEARCH_PATTERN=scan .*:.*log rec MLOG_FILE_CREATE.*page .*:0;
35 --source include/search_pattern.inc
36 # Look for at least one MLOG_INDEX_LOAD in the error log.
37 # Theoretically, it may have been written by this test or an earlier test.
38 # FIXME: redirect the error log of the restart to a new file,
39 # and ensure that we have exactly 3 records there.
40 let SEARCH_PATTERN=scan .*:.*log rec MLOG_INDEX_LOAD;
41 --source include/search_pattern.inc
42
43 CHECK TABLE t1;
44
45 # Remove the --debug=d,ib_log setting.
46 --let $restart_parameters = restart;
47 --source include/restart_mysqld.inc
48
49 DROP TABLE t1;