diff options
| author | Dmitry Shulga <Dmitry.Shulga@Sun.COM> | 2010-10-13 13:27:03 +0700 |
|---|---|---|
| committer | Dmitry Shulga <Dmitry.Shulga@Sun.COM> | 2010-10-13 13:27:03 +0700 |
| commit | 32658e451283a63d2aef228ece1565f84378240f (patch) | |
| tree | fac656384003e2158a9d528276a2f732302b3fb4 /mysql-test/t/grant.test | |
| parent | b79f67eaf4874f9111d59a85d180c4fa9597f417 (diff) | |
| parent | fea55c7ff512b244bce9c0d94c8fb6517d2f5277 (diff) | |
| download | mariadb-git-32658e451283a63d2aef228ece1565f84378240f.tar.gz | |
Auto-merge from mysql-5.1-bugteam for bug#36742.
Diffstat (limited to 'mysql-test/t/grant.test')
| -rw-r--r-- | mysql-test/t/grant.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/grant.test b/mysql-test/t/grant.test index e73f45a6c53..c2bf7f21ffa 100644 --- a/mysql-test/t/grant.test +++ b/mysql-test/t/grant.test @@ -1578,6 +1578,16 @@ DROP TABLE db2.t1; DROP DATABASE db1; DROP DATABASE db2; +--echo # +--echo # Bug #36742 +--echo # +grant usage on Foo.* to myuser@Localhost identified by 'foo'; +grant select on Foo.* to myuser@localhost; +select host,user from mysql.user where User='myuser'; +revoke select on Foo.* from myuser@localhost; +delete from mysql.user where User='myuser'; +flush privileges; + # Wait till we reached the initial number of concurrent sessions --source include/wait_until_count_sessions.inc |