diff options
| author | Alexander Nozdrin <alik@sun.com> | 2009-11-12 15:13:43 +0300 |
|---|---|---|
| committer | Alexander Nozdrin <alik@sun.com> | 2009-11-12 15:13:43 +0300 |
| commit | e29ea6c2f8f0f5346bb3e78552745863799b0c16 (patch) | |
| tree | ebdadd4792f0cd077f82a32327e45f9a63033f36 /mysql-test/t/grant_lowercase_fs.test | |
| parent | 4347bbe3d168e17d87bfb492a5c433866fc19dc6 (diff) | |
| parent | ad6883c4f2df12fe054d996e3ed32669248bfb08 (diff) | |
| download | mariadb-git-e29ea6c2f8f0f5346bb3e78552745863799b0c16.tar.gz | |
Auto-merge from mysql-next-mr.
Diffstat (limited to 'mysql-test/t/grant_lowercase_fs.test')
| -rw-r--r-- | mysql-test/t/grant_lowercase_fs.test | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/t/grant_lowercase_fs.test b/mysql-test/t/grant_lowercase_fs.test new file mode 100644 index 00000000000..f57f950ec8c --- /dev/null +++ b/mysql-test/t/grant_lowercase_fs.test @@ -0,0 +1,30 @@ +-- source include/have_case_insensitive_fs.inc +-- source include/not_embedded.inc + + +# +# Bug#41049 does syntax "grant" case insensitive? +# +create database db1; +GRANT CREATE ON db1.* to user_1@localhost; +GRANT SELECT ON db1.* to USER_1@localhost; + +connect (con1,localhost,user_1,,db1); +CREATE TABLE t1(f1 int); +--error 1142 +SELECT * FROM t1; +connect (con2,localhost,USER_1,,db1); +SELECT * FROM t1; +--error 1142 +CREATE TABLE t2(f1 int); + +connection default; +disconnect con1; +disconnect con2; + +REVOKE ALL PRIVILEGES, GRANT OPTION FROM user_1@localhost; +REVOKE ALL PRIVILEGES, GRANT OPTION FROM USER_1@localhost; +DROP USER user_1@localhost; +DROP USER USER_1@localhost; +DROP DATABASE db1; +use test; |