Debian Codegraph @

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

raw
1 ##################################################################################
2 # Bug#29906115 RENAME OF FTS AUXILARY TABLES DURING UPGRADE COULD FAIL
3 ##################################################################################
4
5 --source include/big_test.inc
6 --source include/not_valgrind.inc
7
8 --echo #
9 --echo # This test upgrades a 5.7 database to 8.x where many FTS AUX tables
10 --echo # can be found.
11 --echo #
12
13 --echo # Stop the running server
14 --source include/shutdown_mysqld.inc
15
16 --echo ##############################################################
17 --echo # Copy and unzip the datadir
18 --echo ##############################################################
19
20 --copy_file $MYSQLTEST_VARDIR/std_data/data57_fts_aux.zip $MYSQL_TMP_DIR/data57_fts_aux.zip
21 --file_exists $MYSQL_TMP_DIR/data57_fts_aux.zip
22 --exec unzip -qo $MYSQL_TMP_DIR/data57_fts_aux.zip -d $MYSQL_TMP_DIR
23 let $DATADIR1 = $MYSQL_TMP_DIR/data57_fts_aux;
24
25 --echo # Restart the server with the unzipped datadir
26 --replace_result $DATADIR1 DATADIR
27 --let $wait_counter=20000
28 --let $restart_parameters = restart: --datadir=$DATADIR1 --innodb_page_size=16k
29 --source include/start_mysqld.inc
30
31 --echo # Check the contents of INFORMATION_SCHEMA
32 SELECT lower(name) FROM INFORMATION_SCHEMA.INNODB_TABLES
33 WHERE name LIKE '%test%'
34 ORDER BY name;
35
36 --echo # Cleanup
37 --echo # Shutdown server
38 --source include/shutdown_mysqld.inc
39
40 --echo # Remove copied files
41 --file_exists $MYSQL_TMP_DIR/data57_fts_aux.zip
42 --force-rmdir $MYSQL_TMP_DIR/data57_fts_aux
43 --remove_file $MYSQL_TMP_DIR/data57_fts_aux.zip
44
45 --echo # Restart the server
46 let $restart_parameters =;
47 --source include/start_mysqld.inc