|
1
by brian
clean slate |
1 |
#
|
2 |
# Specific tests for case sensitive file systems |
|
3 |
# i.e. lower_case_filesystem=OFF |
|
4 |
#
|
|
5 |
-- source include/have_case_sensitive_file_system.inc
|
|
6 |
||
7 |
connect (master,localhost,root,,); |
|
8 |
connection master; |
|
9 |
create database d1; |
|
10 |
grant all on d1.* to 'sample'@'localhost' identified by 'password'; |
|
11 |
flush privileges; |
|
12 |
||
13 |
connect (sample,localhost,sample,password,d1); |
|
14 |
connection sample; |
|
15 |
select database(); |
|
16 |
--error 1044
|
|
17 |
create database d2; |
|
18 |
--error 1044
|
|
19 |
create database D1; |
|
20 |
disconnect sample; |
|
21 |
||
22 |
connection master; |
|
23 |
drop user 'sample'@'localhost'; |
|
24 |
drop database if exists d1; |
|
25 |
disconnect master; |
|
26 |
connection default; |
|
27 |
||
28 |
# End of 4.1 tests |