36 lines
1.3 KiB
Text
36 lines
1.3 KiB
Text
--source include/big_test.inc
|
|
--source include/not_valgrind.inc
|
|
--let $MYSQLD_DATADIR= `select @@datadir`
|
|
|
|
--source include/mysql_upgrade_preparation.inc
|
|
|
|
--echo # FR7: test upgrade
|
|
REVOKE FLUSH_TABLES, FLUSH_USER_RESOURCES, FLUSH_STATUS,
|
|
FLUSH_OPTIMIZER_COSTS, FLUSH_PRIVILEGES ON *.* FROM root@localhost;
|
|
--echo # Should be empty
|
|
SELECT GRANTEE, PRIVILEGE_TYPE, IS_GRANTABLE FROM INFORMATION_SCHEMA.USER_PRIVILEGES
|
|
WHERE PRIVILEGE_TYPE LIKE 'FLUSH_%' ORDER BY 1,2,3;
|
|
|
|
CREATE USER wl14303@localhost, wl14303_no_reload@localhost;
|
|
GRANT RELOAD ON *.* TO wl14303@localhost;
|
|
--echo # Should contain root@localhost and wl14303@localhost
|
|
SELECT GRANTEE, PRIVILEGE_TYPE, IS_GRANTABLE FROM INFORMATION_SCHEMA.USER_PRIVILEGES
|
|
WHERE PRIVILEGE_TYPE = 'RELOAD' ORDER BY 1,2,3;
|
|
|
|
--let $restart_parameters = restart:--upgrade=FORCE
|
|
--let $wait_counter= 10000
|
|
--source include/restart_mysqld.inc
|
|
|
|
--echo # Restart server with defaults
|
|
--let $restart_parameters = restart:
|
|
--source include/restart_mysqld.inc
|
|
|
|
--echo # Success criteria: should contain 8 rows: 5 for root and 5 for wl14303
|
|
SELECT GRANTEE, PRIVILEGE_TYPE, IS_GRANTABLE FROM INFORMATION_SCHEMA.USER_PRIVILEGES
|
|
WHERE PRIVILEGE_TYPE LIKE 'FLUSH_%' ORDER BY 1,2,3;
|
|
DROP USER wl14303@localhost, wl14303_no_reload@localhost;
|
|
|
|
--echo # Cleanup
|
|
--source include/mysql_upgrade_cleanup.inc
|
|
|
|
--echo # End of 8.0 tests
|