Skip to content
  • Raghav Kapoor's avatar
    166f5123
    BUG#13702397 - 64211: 'CREATE TABLE ... LIKE ...' FAILS TO KEEP CASE · 166f5123
    Raghav Kapoor authored
    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.
    166f5123
    BUG#13702397 - 64211: 'CREATE TABLE ... LIKE ...' FAILS TO KEEP CASE
    Raghav Kapoor authored
    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.
Loading