From f54194e24005c16c7c075706663195305495b9f8 Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 28 Apr 2005 15:30:42 -0700 Subject: Fix 'CREATE TABLE ... LIKE ...' when lower_case_table_names is set on case-sensitive file systems and the source table was specified in something other than lowercase. (Bug #9761) mysql-test/r/lowercase_table.result: Add results mysql-test/t/lowercase_table.test: Regression test for Bug #9761 sql/sql_table.cc: When lower_case_table_names is set, make sure to look for the source table using a lowercase filename. --- mysql-test/t/lowercase_table.test | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'mysql-test/t/lowercase_table.test') diff --git a/mysql-test/t/lowercase_table.test b/mysql-test/t/lowercase_table.test index a9c0c976afc..ee8dc403981 100644 --- a/mysql-test/t/lowercase_table.test +++ b/mysql-test/t/lowercase_table.test @@ -73,4 +73,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; -- cgit v1.2.1