summaryrefslogtreecommitdiff
path: root/mysql-test/t/lowercase_table.test
diff options
context:
space:
mode:
authorAlexey Botchkov <holyfoot@askmonty.org>2019-02-01 17:10:27 +0400
committerAlexey Botchkov <holyfoot@askmonty.org>2019-02-01 17:10:27 +0400
commit09cea8703f3ec4e4f9e23855a339c9e3d5e84d3b (patch)
tree54779ab712b4a87e9207217c03c1397a70c4297c /mysql-test/t/lowercase_table.test
parent7c7161a1bd150e61f530933f096a8035932071af (diff)
downloadmariadb-git-09cea8703f3ec4e4f9e23855a339c9e3d5e84d3b.tar.gz
MDEV-17148 DROP DATABASE throw "Directory not empty" after changed lower_case_table_names.
No need to lowercase table names on case-sensitive file systems, as the cache won't contain the 'lowercased' table anyway. And it prevents the UPPERCASE.frm from being deleted.
Diffstat (limited to 'mysql-test/t/lowercase_table.test')
-rw-r--r--mysql-test/t/lowercase_table.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/lowercase_table.test b/mysql-test/t/lowercase_table.test
index c339105aae4..e0dcb6c36dd 100644
--- a/mysql-test/t/lowercase_table.test
+++ b/mysql-test/t/lowercase_table.test
@@ -118,3 +118,15 @@ show databases like "mysql_TE%";
drop database mysql_TEST;
--echo End of 10.0 tests
+
+#
+# MDEV-17148 DROP DATABASE throw "Directory not empty" after changed lower_case_table_names.
+#
+
+let $datadir=`select @@datadir`;
+create database db1;
+create table t1 (a int);
+copy_file $datadir/test/t1.frm $datadir/db1/T1.frm;
+drop database db1;
+drop table t1;
+