← Back to branch summary

~vadim-tk/percona-server/flushing-algo

« back to all changes in this revision

Viewing changes to mysql-test/t/grant_lowercase_fs.test

  • Committer: root
  • Date: 2011-10-29 01:34:40 UTC
  • Revision ID: root@hppro1.office.percona.com-20111029013440-qhnf4jk8kdjcf4e0
Initial import

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/grant_lowercase_fs.test
 
1
-- source include/have_case_insensitive_fs.inc
 
2
-- source include/not_embedded.inc
 
3
 
 
4
 
 
5
#
 
6
# Bug#41049 does syntax "grant" case insensitive?
 
7
#
 
8
create database db1;
 
9
GRANT CREATE ON db1.* to user_1@localhost;
 
10
GRANT SELECT ON db1.* to USER_1@localhost;
 
11
 
 
12
connect (con1,localhost,user_1,,db1);
 
13
CREATE TABLE t1(f1 int);
 
14
--error 1142
 
15
SELECT * FROM t1;
 
16
connect (con2,localhost,USER_1,,db1);
 
17
SELECT * FROM t1;
 
18
--error 1142
 
19
CREATE TABLE t2(f1 int);
 
20
 
 
21
connection default;
 
22
disconnect con1;
 
23
disconnect con2;
 
24
 
 
25
REVOKE ALL PRIVILEGES, GRANT OPTION FROM user_1@localhost;
 
26
REVOKE ALL PRIVILEGES, GRANT OPTION FROM USER_1@localhost;
 
27
DROP USER user_1@localhost;
 
28
DROP USER USER_1@localhost;
 
29
DROP DATABASE db1;
 
30
use test;