################################################################################## # Bug#29906115 RENAME OF FTS AUXILARY TABLES DURING UPGRADE COULD FAIL ################################################################################## --source include/big_test.inc --source include/not_valgrind.inc --echo # --echo # This test upgrades a 5.7 database to 8.x where many FTS AUX tables --echo # can be found. --echo # --echo # Stop the running server --source include/shutdown_mysqld.inc --echo ############################################################## --echo # Copy and unzip the datadir --echo ############################################################## --copy_file $MYSQLTEST_VARDIR/std_data/data57_fts_aux.zip $MYSQL_TMP_DIR/data57_fts_aux.zip --file_exists $MYSQL_TMP_DIR/data57_fts_aux.zip --exec unzip -qo $MYSQL_TMP_DIR/data57_fts_aux.zip -d $MYSQL_TMP_DIR let $DATADIR1 = $MYSQL_TMP_DIR/data57_fts_aux; --echo # Restart the server with the unzipped datadir --replace_result $DATADIR1 DATADIR --let $wait_counter=20000 --let $restart_parameters = restart: --datadir=$DATADIR1 --innodb_page_size=16k --source include/start_mysqld.inc --echo # Check the contents of INFORMATION_SCHEMA SELECT lower(name) FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE name LIKE '%test%' ORDER BY name; --echo # Cleanup --echo # Shutdown server --source include/shutdown_mysqld.inc --echo # Remove copied files --file_exists $MYSQL_TMP_DIR/data57_fts_aux.zip --force-rmdir $MYSQL_TMP_DIR/data57_fts_aux --remove_file $MYSQL_TMP_DIR/data57_fts_aux.zip --echo # Restart the server let $restart_parameters =; --source include/start_mysqld.inc