Debian Codegraph @

mysql-test/suite/innodb/t/instant_ddl_upgrade_rollback.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 (id INT PRIMARY KEY, c1 VARCHAR(4000), c2 VARCHAR(4000)) ROW_FORMAT=REDUNDANT;
13 # INSERT INTO t1 VALUES(1, repeat('a', 4000), repeat('b', 4000));
14 # ALTER TABLE t1 ADD COLUMN c3 VARCHAR(500) NOT NULL DEFAULT 'dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd', ALGORITHM=INSTANT;
15 #
16 # CREATE TABLE t1_compact (id INT PRIMARY KEY, c1 VARCHAR(4000), c2 VARCHAR(4000)) ROW_FORMAT=COMPACT;
17 # INSERT INTO t1 VALUES(1, repeat('a', 4000), repeat('b', 4000));
18 # ALTER TABLE t1 ADD COLUMN c3 VARCHAR(500) NOT NULL DEFAULT 'dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd', ALGORITHM=INSTANT;
19 #
20 # CREATE TABLE t1_dynamic (id INT PRIMARY KEY, c1 VARCHAR(4000), c2 VARCHAR(4000)) ROW_FORMAT=DYNAMIC;
21 # INSERT INTO t1 VALUES(1, repeat('a', 4000), repeat('b', 4000));
22 # ALTER TABLE t1 ADD COLUMN c3 VARCHAR(500) NOT NULL DEFAULT 'dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd', ALGORITHM=INSTANT;
23 # ------------------------------------------------------------
24
25 --echo #########
26 --echo # SETUP #
27 --echo #########
28
29 --echo # Stop the running the server
30 --source include/shutdown_mysqld.inc
31
32 --echo # Copy and unzip the datadir.
33 --copy_file $MYSQLTEST_VARDIR/std_data/instant_ddl/data_instant_ddl_upgrade_rollback.zip $MYSQL_TMP_DIR/data_instant_ddl_upgrade_rollback.zip
34 --file_exists $MYSQL_TMP_DIR/data_instant_ddl_upgrade_rollback.zip
35 --exec unzip -qo $MYSQL_TMP_DIR/data_instant_ddl_upgrade_rollback.zip -d $MYSQL_TMP_DIR
36 let $DATADIR = $MYSQL_TMP_DIR/data;
37
38 --echo # Restart the server against the unzipped datadir
39 --replace_result $DATADIR DATADIR
40 --let $restart_parameters = restart: --datadir=$DATADIR --innodb-page-size=4k
41 --let $wait_counter=3000
42 --source include/start_mysqld.inc
43
44 --echo ##############################################
45 --echo # Test instant ADD/DROP COLUMN for REDUNDANT format
46 --echo ##############################################
47 let $row_format = redundant;
48 --source suite/innodb/include/instant_ddl_upgrade_rollback.inc
49
50 --echo ############################################
51 --echo # Test instant ADD/DROP COLUMN for DYNAMIC format
52 --echo ############################################
53 let $row_format = dynamic;
54 --source suite/innodb/include/instant_ddl_upgrade_rollback.inc
55
56 --echo ############################################
57 --echo # Test instant ADD/DROP COLUMN for COMPACT format
58 --echo ############################################
59 let $row_format = compact;
60 --source suite/innodb/include/instant_ddl_upgrade_rollback.inc
61
62 --echo ###########
63 --echo # CLEANUP #
64 --echo ###########
65
66 --echo # Shutdown server
67 --source include/shutdown_mysqld.inc
68
69 --echo # Remove copied files
70 --file_exists $MYSQL_TMP_DIR/data_instant_ddl_upgrade_rollback.zip
71 --force-rmdir $MYSQL_TMP_DIR/data
72 --remove_file $MYSQL_TMP_DIR/data_instant_ddl_upgrade_rollback.zip
73
74 --echo # Restarting server to restore server state
75 let $restart_parameters =;
76 --source include/start_mysqld.inc