Debian Codegraph @

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

raw
1 ##########################################################################
2 # Test script to test UPGRADE from older version table (not) having
3 # INSTANT ADD columns.
4 ##########################################################################
5
6 --source include/not_valgrind.inc
7 --source include/have_lowercase0.inc
8
9 # ------------------------------------------------------------
10 # Tables created on earlier version with following
11 # ------------------------------------------------------------
12 # Create table t1_redundant (c1 char(10), c2 char(10)) ROW_FORMAT=REDUNDANT;
13 # Insert into t1_redundant values ("r1c1", "r1c2");
14 # Select * from t1_redundant;
15 # Alter table t1_redundant add column c3 char(10) default "c3_def", algorithm=instant;
16 # Insert into t1_redundant values ("r2c1", "r2c2", "r2c3");
17 # Select * from t1_redundant;
18 # Alter table t1_redundant add column c4 char(10) default "c4_def", algorithm=instant;
19 # Insert into t1_redundant values ("r3c1", "r3c2", "r3c3", "r3c4");
20 # Select * from t1_redundant;
21 #
22 # Create table t1_dynamic (c1 char(10), c2 char(10)) ROW_FORMAT=DYNAMIC;
23 # Insert into t1_dynamic values ("r1c1", "r1c2");
24 # Select * from t1_dynamic;
25 # Alter table t1_dynamic add column c3 char(10) default "c3_def", algorithm=instant;
26 # Insert into t1_dynamic values ("r2c1", "r2c2", "r2c3");
27 # Select * from t1_dynamic;
28 # Alter table t1_dynamic add column c4 char(10) default "c4_def", algorithm=instant;
29 # Insert into t1_dynamic values ("r3c1", "r3c2", "r3c3", "r3c4");
30 # Select * from t1_dynamic;
31 #
32 # Create table t1_compact (c1 char(10), c2 char(10)) ROW_FORMAT=COMPACT;
33 # Insert into t1_compact values ("r1c1", "r1c2");
34 # Select * from t1_compact;
35 # Alter table t1_compact add column c3 char(10) default "c3_def", algorithm=instant;
36 # Insert into t1_compact values ("r2c1", "r2c2", "r2c3");
37 # Select * from t1_compact;
38 # Alter table t1_compact add column c4 char(10) default "c4_def", algorithm=instant;
39 # Insert into t1_compact values ("r3c1", "r3c2", "r3c3", "r3c4");
40 # Select * from t1_compact;
41 #
42 # Create table t2_redundant (c1 char(10), c2 char(10)) ROW_FORMAT=REDUNDANT;
43 # Insert into t2_redundant values ("r1c1", "r1c2");
44 # Select * from t2_redundant;
45 # Alter table t2_redundant add column c3 char(10) default "c3_def", algorithm=INSTANT;
46 # Insert into t2_redundant values ("r2c1", "r2c2", "r2c3");
47 # Select * from t2_redundant;
48 #
49 # Create table t2_dynamic (c1 char(10), c2 char(10)) ROW_FORMAT=DYNAMIC;
50 # Insert into t2_dynamic values ("r1c1", "r1c2");
51 # Select * from t2_dynamic;
52 # Alter table t2_dynamic add column c3 char(10) default "c3_def", algorithm=INSTANT;
53 # Insert into t2_dynamic values ("r2c1", "r2c2", "r2c3");
54 # Select * from t2_dynamic;
55 #
56 # Create table t2_compact (c1 char(10), c2 char(10)) ROW_FORMAT=COMPACT;
57 # Insert into t2_compact values ("r1c1", "r1c2");
58 # Select * from t2_compact;
59 # Alter table t2_compact add column c3 char(10) default "c3_def", algorithm=INSTANT;
60 # Insert into t2_compact values ("r2c1", "r2c2", "r2c3");
61 # Select * from t2_compact;
62 # ------------------------------------------------------------
63
64 --echo #########
65 --echo # SETUP #
66 --echo #########
67
68 --echo # Stop the running the server
69 --source include/shutdown_mysqld.inc
70
71 --echo # Copy and unzip the datadir.
72 --copy_file $MYSQLTEST_VARDIR/std_data/instant_ddl/data_instant_ddl_upgrade.zip $MYSQL_TMP_DIR/data_instant_ddl_upgrade.zip
73 --file_exists $MYSQL_TMP_DIR/data_instant_ddl_upgrade.zip
74 --exec unzip -qo $MYSQL_TMP_DIR/data_instant_ddl_upgrade.zip -d $MYSQL_TMP_DIR
75 let $DATADIR = $MYSQL_TMP_DIR/data;
76
77 --echo # Restart the server against the unzipped datadir
78 --replace_result $DATADIR DATADIR
79 --let $restart_parameters = restart: --datadir=$DATADIR --innodb-page-size=16k
80 --let $wait_counter=3000
81 --source include/start_mysqld.inc
82
83 --echo ##############################################
84 --echo # Test instant ADD/DROP COLUMN for REDUNDANT format
85 --echo ##############################################
86 let $row_format = redundant;
87 --source suite/innodb/include/instant_ddl_upgrade.inc
88
89 --echo ############################################
90 --echo # Test instant ADD/DROP COLUMN for DYNAMIC format
91 --echo ############################################
92 let $row_format = dynamic;
93 --source suite/innodb/include/instant_ddl_upgrade.inc
94
95 --echo ############################################
96 --echo # Test instant ADD/DROP COLUMN for COMPACT format
97 --echo ############################################
98 let $row_format = compact;
99 --source suite/innodb/include/instant_ddl_upgrade.inc
100
101 --echo ###########
102 --echo # CLEANUP #
103 --echo ###########
104
105 --echo # Shutdown server
106 --source include/shutdown_mysqld.inc
107
108 --echo # Remove copied files
109 --file_exists $MYSQL_TMP_DIR/data_instant_ddl_upgrade.zip
110 --force-rmdir $MYSQL_TMP_DIR/data
111 --remove_file $MYSQL_TMP_DIR/data_instant_ddl_upgrade.zip
112
113 --echo # Restarting server to restore server state
114 let $restart_parameters =;
115 --source include/start_mysqld.inc