# Can't run test of external client with embedded server -- source include/not_embedded.inc # Only run test if "mysql_upgrade" is found --require r/have_mysql_upgrade.result --disable_query_log select LENGTH("$MYSQL_UPGRADE")>0 as have_mysql_upgrade; --enable_query_log # # Basic test that we can run mysql_upgrde and that it finds the # expected binaries it uses. # --echo Run mysql_upgrade once --exec $MYSQL_UPGRADE --skip-verbose 2>&1 # It should have created a file in the MySQL Servers datadir file_exists $MYSQLTEST_VARDIR/master-data/mysql_upgrade_info; --echo Run it again - should say already completed --replace_result $MYSQL_SERVER_VERSION VERSION --error 1 --exec $MYSQL_UPGRADE --skip-verbose 2>&1 # It should have created a file in the MySQL Servers datadir file_exists $MYSQLTEST_VARDIR/master-data/mysql_upgrade_info; --echo Force should run it regardless of wether it's been run before --exec $MYSQL_UPGRADE --skip-verbose --force 2>&1 # It should have created a file in the MySQL Servers datadir file_exists $MYSQLTEST_VARDIR/master-data/mysql_upgrade_info; # # Bug #25452 mysql_upgrade access denied. # # Password protect a root account and run mysql_upgrade CREATE USER mysqltest1@'%' IDENTIFIED by 'sakila'; GRANT ALL ON *.* TO mysqltest1@'%'; --echo Run mysql_upgrade with password protected account --exec $MYSQL_UPGRADE --skip-verbose --force --user=mysqltest1 --password=sakila 2>&1 DROP USER mysqltest1@'%'; # # Bug #26639 mysql_upgrade exits successfully even if external command failed # --echo Run mysql_upgrade with a non existing server socket --replace_result $MYSQLTEST_VARDIR var --replace_regex /.*mysqlcheck.*: Got/mysqlcheck: Got/ /\([0-9]*\)/(errno)/ --error 1 --exec $MYSQL_UPGRADE --skip-verbose --force --host=not_existing_host 2>&1 # # Bug #28401 mysql_upgrade Failed with STRICT_ALL_TABLES, ANSI_QUOTES and NO_ZERO_DATE # # The SQL commands used by mysql_upgrade are written to be run # with sql_mode set to '' - thus the scripts should change sql_mode # for the session to make sure the SQL is legal. # Test by setting sql_mode before running mysql_upgrade set GLOBAL sql_mode='STRICT_ALL_TABLES,ANSI_QUOTES,NO_ZERO_DATE'; --exec $MYSQL_UPGRADE --skip-verbose --force 2>&1 eval set GLOBAL sql_mode=default;