summaryrefslogtreecommitdiff
path: root/mysql-test/include/have_case_sensitive_file_system.inc
diff options
context:
space:
mode:
authorunknown <bar@mysql.com>2006-05-04 11:55:09 +0500
committerunknown <bar@mysql.com>2006-05-04 11:55:09 +0500
commitaf2f9b90fa7e90468eadfbb24256b0be87dd5184 (patch)
tree99b034d10717c94a9a3958ad7c85015c0cdee0f4 /mysql-test/include/have_case_sensitive_file_system.inc
parent38b1f7c7c3790a6ee59dd213eab16fe9c6fd97f4 (diff)
downloadmariadb-git-af2f9b90fa7e90468eadfbb24256b0be87dd5184.tar.gz
Bugs#17647: Trouble with "create database"
Problem: if a user was granted privileges on database "d1", it also was able to act on "D1" (i.e. in upper case), even on Unix with case sensitive file system. Fix: Initialize grant hash to use binary comparison if lower_case_file_system is not set (on most unixes), and case insensitive comparison otherwise (Windows, MacOSX). sql/sql_acl.cc: Initialize hash to use binary comparison with case sensitive FS. mysql-test/include/have_case_sensitive_file_system.inc: New BitKeeper file ``mysql-test/include/have_case_sensitive_file_system.inc'' Backporting from 5.1 mysql-test/r/case_sensitive_file_system.require: New BitKeeper file ``mysql-test/r/case_sensitive_file_system.require'' Backporting from 5.1 mysql-test/r/lowercase_fs_off.result: Adding test case mysql-test/t/lowercase_fs_off.test: Adding test case
Diffstat (limited to 'mysql-test/include/have_case_sensitive_file_system.inc')
-rw-r--r--mysql-test/include/have_case_sensitive_file_system.inc4
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/include/have_case_sensitive_file_system.inc b/mysql-test/include/have_case_sensitive_file_system.inc
new file mode 100644
index 00000000000..730af975497
--- /dev/null
+++ b/mysql-test/include/have_case_sensitive_file_system.inc
@@ -0,0 +1,4 @@
+--require r/case_sensitive_file_system.require
+--disable_query_log
+show variables like "lower_case_file_system";
+--enable_query_log