40 lines
1.1 KiB
Plaintext
40 lines
1.1 KiB
Plaintext
# This test intends to test that the MySQL upgrade process will create the
|
|
# user 'mysql.infoschema' that is an owner of views in inforamtion_schema.
|
|
#
|
|
|
|
-- source include/no_valgrind_without_big.inc
|
|
--source include/mysql_upgrade_preparation.inc
|
|
|
|
let $date_to_restore=`SELECT password_last_changed FROM mysql.user WHERE user='mysql.infoschema'`;
|
|
|
|
--echo #
|
|
--echo # Delete the user
|
|
--echo # Check that upgrade recreates it
|
|
--echo #
|
|
|
|
DELETE FROM mysql.user WHERE user='mysql.infoschema';
|
|
COMMIT;
|
|
|
|
--echo Run mysql_upgrade
|
|
# Filter out ndb_binlog_index to mask differences due to running with or
|
|
# without ndb.
|
|
--let $restart_parameters = restart:--upgrade=FORCE
|
|
--let $wait_counter= 10000
|
|
--source include/restart_mysqld.inc
|
|
|
|
--let $assert_text= The mysql.infoschema user should exist after upgrade
|
|
--let $assert_cond= "[SELECT COUNT(*) FROM mysql.user WHERE user=\'mysql.infoschema\']" = 1
|
|
--source include/assert.inc
|
|
|
|
--echo #
|
|
--echo # Clean up
|
|
--echo #
|
|
|
|
--disable_query_log ONCE
|
|
--eval UPDATE mysql.user SET password_last_changed= '$date_to_restore' WHERE USER= 'mysql.infoschema'
|
|
|
|
--source include/mysql_upgrade_cleanup.inc
|
|
|
|
--echo
|
|
--echo End of test
|