EVOLUTION-MANAGER

Edit File: log_alter_table.test

--source include/have_innodb.inc --source include/have_debug.inc # Embedded server does not support crashing --source include/not_embedded.inc # start afresh --source include/restart_mysqld.inc --echo # --echo # Bug#21801423 INNODB REDO LOG DOES NOT INDICATE WHEN --echo # FILES ARE CREATED --echo # --echo # Bug#21796691 INNODB REDO LOG DOES NOT INDICATE WHEN --echo # REDO LOGGING IS SKIPPED --echo # --source include/no_checkpoint_start.inc CREATE TABLE t1 (a INT NOT NULL, b INT UNIQUE) ENGINE=InnoDB; # MLOG_INDEX_LOAD will not be emitted for empty tables. Insert a row. INSERT INTO t1 VALUES (1,2); # We should get two MLOG_INDEX_LOAD for this. ALTER TABLE t1 ADD PRIMARY KEY(a), LOCK=SHARED, ALGORITHM=INPLACE; # And one MLOG_INDEX_LOAD for this. ALTER TABLE t1 DROP INDEX b, ADD INDEX (b), LOCK=SHARED; --let CLEANUP_IF_CHECKPOINT=DROP TABLE t1; --source include/no_checkpoint_end.inc --let $restart_parameters= --debug=d,ib_log --source include/start_mysqld.inc let SEARCH_FILE = $MYSQLTEST_VARDIR/log/mysqld.1.err; let SEARCH_ABORT=NOT FOUND; # ensure that we have exactly 2 records there. let SEARCH_PATTERN=scan \d+: multi-log rec MLOG_FILE_CREATE2 len \d+ page \d+:0; --source include/search_pattern_in_file.inc # ensure that we have exactly 3 records there. let SEARCH_PATTERN=scan \d+: log rec MLOG_INDEX_LOAD; --source include/search_pattern_in_file.inc CHECK TABLE t1; # Remove the --debug=d,ib_log setting. --let $restart_parameters= --source include/restart_mysqld.inc DROP TABLE t1;