################################################################################## # Bug#30330448 upgrade from 5.7 to 8.0.17 causes duplicate entries for partitioned table ################################################################################## --source include/have_debug.inc --source include/not_valgrind.inc --source include/have_case_sensitive_file_system.inc --echo # --echo # This test upgrades a 5.7 database to 8.0 and validates that no --echo # PRIMARY index entries are seen in mysql.innodb_index_stats --echo # if there are no primary keys defined on the table --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_index_stats.zip $MYSQL_TMP_DIR/data57_index_stats.zip --file_exists $MYSQL_TMP_DIR/data57_index_stats.zip --exec unzip -qo $MYSQL_TMP_DIR/data57_index_stats.zip -d $MYSQL_TMP_DIR let $DATADIR1 = $MYSQL_TMP_DIR/data57_index_stats; --echo # Restart the server with the unzipped datadir --replace_result $DATADIR1 DATADIR --let $wait_counter=3000 --let $restart_parameters = restart: --datadir=$DATADIR1 --innodb_page_size=16k --source include/start_mysqld.inc --echo # Check the contents of mysql.innodb_index_stats SHOW CREATE TABLE t_nopart; SHOW CREATE TABLE t_no_part_pk; SHOW CREATE TABLE t_part; SHOW CREATE TABLE t_part_pk; SELECT lower(database_name), lower(table_name), lower(index_name), lower(stat_name) FROM mysql.innodb_index_stats ORDER BY lower(database_name), lower(table_name), lower(index_name), lower(stat_name); --echo # Cleanup --echo # Shutdown server --source include/shutdown_mysqld.inc --echo # Remove copied files --file_exists $MYSQL_TMP_DIR/data57_index_stats.zip --force-rmdir $MYSQL_TMP_DIR/data57_index_stats --remove_file $MYSQL_TMP_DIR/data57_index_stats.zip --echo # Restart the server let $restart_parameters =; --source include/start_mysqld.inc