diff options
author | Sergei Golubchik <serg@mariadb.org> | 2020-04-21 18:45:12 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2020-04-27 09:22:36 +0200 |
commit | 2144dc1ff2916ba1c0b0fded9cb7022b9ecf47a9 (patch) | |
tree | 1eeb0fb21bb62dca9bf478da685df0de35dc07f4 /mysql-test/main/mysql_upgrade.result | |
parent | b976b9bfc3ec12cf4dcf57da828c0315916c1413 (diff) | |
download | mariadb-git-2144dc1ff2916ba1c0b0fded9cb7022b9ecf47a9.tar.gz |
more verbose tests
Diffstat (limited to 'mysql-test/main/mysql_upgrade.result')
-rw-r--r-- | mysql-test/main/mysql_upgrade.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/main/mysql_upgrade.result b/mysql-test/main/mysql_upgrade.result index 862e7e8f3d4..33c3d1b8198 100644 --- a/mysql-test/main/mysql_upgrade.result +++ b/mysql-test/main/mysql_upgrade.result @@ -575,6 +575,7 @@ SET GLOBAL enforce_storage_engine=NULL; # Ensure that mysql_upgrade correctly sets truncate_versioning_priv # on upgrade from 10.2 # +# switching from mysql.global_priv to mysql.user drop view mysql.user_bak; CREATE USER 'user3'@'%'; GRANT USAGE ON *.* TO 'user3'@'%'; @@ -593,6 +594,7 @@ update mysql.db set Delete_history_priv='Y' where db like 'test%'; drop table mysql.global_priv; rename table mysql.global_priv_bak to mysql.global_priv; # End of 10.3 tests +# switching from mysql.global_priv to mysql.user drop view mysql.user_bak; create user 'user3'@'localhost' identified with mysql_native_password as password('a_password'); show create user user3@localhost; @@ -625,11 +627,13 @@ connection default; drop user user3@localhost; drop table mysql.global_priv; rename table mysql.global_priv_bak to mysql.global_priv; +# switching from mysql.global_priv to mysql.user drop view mysql.user_bak; drop table mysql.innodb_index_stats, mysql.innodb_table_stats; # mysql_upgrade --force --silent 2>&1 drop table mysql.global_priv; rename table mysql.global_priv_bak to mysql.global_priv; +# switching from mysql.global_priv to mysql.user drop view mysql.user_bak; alter table mysql.user change authentication_string auth_string text collate utf8_bin not null; # mysql_upgrade --force --silent 2>&1 |