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/r | |
| 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/r')
| -rw-r--r-- | mysql-test/r/grant.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/grant.result b/mysql-test/r/grant.result index 6831ef6183d..f6277323964 100644 --- a/mysql-test/r/grant.result +++ b/mysql-test/r/grant.result @@ -1429,3 +1429,14 @@ DROP USER 'testbug'@localhost; DROP TABLE db2.t1; DROP DATABASE db1; DROP DATABASE db2; +# +# Bug #36742 +# +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'; +host user +localhost myuser +revoke select on Foo.* from myuser@localhost; +delete from mysql.user where User='myuser'; +flush privileges; |