diff options
| author | Dmitry Shulga <Dmitry.Shulga@Sun.COM> | 2010-10-13 12:28:58 +0700 |
|---|---|---|
| committer | Dmitry Shulga <Dmitry.Shulga@Sun.COM> | 2010-10-13 12:28:58 +0700 |
| commit | 8169faec2797511e649bd98329c69a6cb0c9a857 (patch) | |
| tree | 846c278edb809b55566a9fa0259be03b18fdb09f /mysql-test/t/grant.test | |
| parent | 42f8d2f249ea4d0acc2fdd7c03b3ea9d44f92027 (diff) | |
| download | mariadb-git-8169faec2797511e649bd98329c69a6cb0c9a857.tar.gz | |
Fixed bug#36742 - GRANT hostname case handling inconsistent.
mysql-test/r/grant.result:
It was added result for test case for bug#36742.
mysql-test/t/grant.test:
It was added test case for bug#36742.
sql/sql_yacc.yy:
It was added convertation of host name part of user name to lowercase.
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 cb8d3c63be8..2fafeb7d264 100644 --- a/mysql-test/t/grant.test +++ b/mysql-test/t/grant.test @@ -1550,5 +1550,15 @@ 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 |