summaryrefslogtreecommitdiff
path: root/mysql-test/t/lowercase_table.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/lowercase_table.test')
-rw-r--r--mysql-test/t/lowercase_table.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/lowercase_table.test b/mysql-test/t/lowercase_table.test
index f6142b3ddfd..d60ad06b3a7 100644
--- a/mysql-test/t/lowercase_table.test
+++ b/mysql-test/t/lowercase_table.test
@@ -74,4 +74,12 @@ select * from t1 c, t2 C;
select C.a, c.a from t1 c, t2 C;
drop table t1, t2;
+#
+# Bug #9761: CREATE TABLE ... LIKE ... not handled correctly when
+# lower_case_table_names is set
+
+create table t1 (a int);
+create table t2 like T1;
+drop table t1, t2;
+
show tables;