Create 'main' test directory and move 't' and 'r' there

1 files changed, 23 insertions, 0 deletions

diff --git a/mysql-test/main/grant_lowercase_fs.result b/mysql-test/main/grant_lowercase_fs.result
new file mode 100644
index 00000000000..e883067eca0
--- /dev/null
+++ b/mysql-test/main/grant_lowercase_fs.result
@@ -0,0 +1,23 @@
+create database db1;
+create user user_1@localhost;
+create user USER_1@localhost;
+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);
+SELECT * FROM t1;
+ERROR 42000: SELECT command denied to user 'user_1'@'localhost' for table 't1'
+connect  con2,localhost,USER_1,,db1;
+SELECT * FROM t1;
+f1
+CREATE TABLE t2(f1 int);
+ERROR 42000: CREATE command denied to user 'USER_1'@'localhost' for table 't2'
+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;