diff options
| author | Georgi Kodinov <Georgi.Kodinov@Oracle.com> | 2010-07-05 13:22:13 +0300 |
|---|---|---|
| committer | Georgi Kodinov <Georgi.Kodinov@Oracle.com> | 2010-07-05 13:22:13 +0300 |
| commit | db6afa75b4624360ce67c46765e1fd7b4d68fbe8 (patch) | |
| tree | c7f379ff7d95ee50552e1349c6847d4dfa34beba /mysql-test/t/mysql_upgrade.test | |
| parent | ea140d862e01fe5d7c5cabb6367dcef21a595980 (diff) | |
| parent | 279b3adfc78ae93f976eb8797f41c64f3bc6b4bb (diff) | |
| download | mariadb-git-db6afa75b4624360ce67c46765e1fd7b4d68fbe8.tar.gz | |
merge
Diffstat (limited to 'mysql-test/t/mysql_upgrade.test')
| -rw-r--r-- | mysql-test/t/mysql_upgrade.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/mysql_upgrade.test b/mysql-test/t/mysql_upgrade.test index 83d97954222..3ea612d2ca7 100644 --- a/mysql-test/t/mysql_upgrade.test +++ b/mysql-test/t/mysql_upgrade.test @@ -108,6 +108,23 @@ DROP PROCEDURE testproc; --cat_file $MYSQLTEST_VARDIR/tmp/41569.txt --remove_file $MYSQLTEST_VARDIR/tmp/41569.txt + +--echo # +--echo # Bug #53613: mysql_upgrade incorrectly revokes +--echo # TRIGGER privilege on given table +--echo # + +GRANT USAGE ON *.* TO 'user3'@'%'; +GRANT ALL PRIVILEGES ON `roelt`.`test2` TO 'user3'@'%'; +--echo Run mysql_upgrade with all privileges on a user +--exec $MYSQL_UPGRADE --skip-verbose --force 2>&1 +SHOW GRANTS FOR 'user3'@'%'; + +DROP USER 'user3'@'%'; + +--echo End of 5.1 tests + + # # Test the --upgrade-system-tables option # |