MySQL BUG#13702397 - 64211: 'CREATE TABLE ... LIKE ...' FAILS TO KEEP CASE

revno: 3690.1.153

committer: Raghav Kapoor <raghav.kapoor@oracle.com>

branch nick: mysql-trunk-bug-13702397

timestamp: Fri 2012-03-23 15:26:55 +0530

message:

  BUG#13702397 - 64211: 'CREATE TABLE ... LIKE ...' FAILS TO KEEP CASE

  BACKGROUND:

  Regular Create Table Statements properly keep the case on

  a case insensitive file system like Windows or Mac OS X when

  lower_case_table_names= 2 whereas while creating tables LIKE

  another (create table <tablename> LIKE <tablename>), the table

  name case is ignored on a case insensitive file system when

  lower_case_table_names= 2. This problem is mentioned as part

  of this bug report. This behaviour was annoying and not

  consistent with the documentation.

  FIX:

  This bug is fixed by populating the alias in local_create_info

  structure in mysql_create_like_table function when create table

  <tablename> LIKE <tablename> query is issued equal to alias

  information that is stored in create_info structure.This

  assignment was missing due to which this bug was happening.

  Also a testcase has been written in lowercase_table2.test and

  the corresponding result file has also been updated.