diff options
Diffstat (limited to 'mysql-test/main/mysql_upgrade.result')
-rw-r--r-- | mysql-test/main/mysql_upgrade.result | 59 |
1 files changed, 59 insertions, 0 deletions
diff --git a/mysql-test/main/mysql_upgrade.result b/mysql-test/main/mysql_upgrade.result index 84628e6d504..d41df55b113 100644 --- a/mysql-test/main/mysql_upgrade.result +++ b/mysql-test/main/mysql_upgrade.result @@ -643,3 +643,62 @@ count(*) drop table mysql.global_priv; rename table mysql.global_priv_bak to mysql.global_priv; # End of 10.4 tests +# +# Check that mysql_upgrade can be run on mysqldump +# of mysql schema from previous versions +# +call mtr.add_suppression("innodb_table_stats has length mismatch in the column name table_name"); +# +# Upgrade from version 5.5 +# +# Loading dump of 5.5 mysql schema +# Running mysql_upgrade +# Checking that mysql.user is accessible and returns some data +SELECT COUNT(*) > 0 AS `mysql.user has data` FROM mysql.user; +mysql.user has data +1 +# +# Upgrade from version 10.0 +# +# Loading dump of 10.0 mysql schema +# Running mysql_upgrade +# Checking that mysql.user is accessible and returns some data +SELECT COUNT(*) > 0 AS `mysql.user has data` FROM mysql.user; +mysql.user has data +1 +# +# Upgrade from version 10.1 +# +# Loading dump of 10.1 mysql schema +# Running mysql_upgrade +# Checking that mysql.user is accessible and returns some data +SELECT COUNT(*) > 0 AS `mysql.user has data` FROM mysql.user; +mysql.user has data +1 +# +# Upgrade from version 10.2 +# +# Loading dump of 10.2 mysql schema +# Running mysql_upgrade +# Checking that mysql.user is accessible and returns some data +SELECT COUNT(*) > 0 AS `mysql.user has data` FROM mysql.user; +mysql.user has data +1 +# +# Upgrade from version 10.3 +# +# Loading dump of 10.3 mysql schema +# Running mysql_upgrade +# Checking that mysql.user is accessible and returns some data +SELECT COUNT(*) > 0 AS `mysql.user has data` FROM mysql.user; +mysql.user has data +1 +# +# Upgrade from version 10.4 +# +# Loading dump of 10.4 mysql schema +# Running mysql_upgrade +# Checking that mysql.user is accessible and returns some data +SELECT COUNT(*) > 0 AS `mysql.user has data` FROM mysql.user; +mysql.user has data +1 |