~drizzle-trunk/drizzle/development

# 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;