Debian Codegraph @

mysql-test/suite/innodb/include/instant_ddl_recovery_old_2.inc

raw
1 ##########################################################################
2 # Test script to test RECOVERY of a crashed server in older release with
3 # table having INSTANT ADD columns.
4 #
5 # $row_format is to be set to the row_format on which test is to be run.
6 ##########################################################################
7
8 --echo #########
9 --echo # SETUP #
10 --echo #########
11
12 --let $table_name=t1_$row_format
13 --source suite/innodb/include/print_instant_metadata.inc
14
15 eval SELECT * FROM t1_$row_format;
16
17 # Make sure nothing is flush and REDO log has entries for INSERT transaction
18 SET GLOBAL innodb_log_checkpoint_now = ON;
19 SET GLOBAL innodb_page_cleaner_disabled_debug = 1;
20 SET GLOBAL innodb_dict_stats_disabled_debug = 1;
21 SET GLOBAL innodb_master_thread_disabled_debug = 1;
22
23 eval INSERT INTO t1_$row_format VALUES ("r2c1", "r2c2", "r2c3");
24
25 --echo # Restart running server.
26 # It should apply logged entries for INSERT transaction
27 --source include/restart_mysqld_no_echo.inc
28
29 eval SELECT * FROM t1_$row_format;
30
31 --source suite/innodb/include/print_instant_metadata.inc
32
33 --echo ###########
34 --echo # CLEANUP #
35 --echo ###########
36 eval DROP TABLE t1_$row_format;