-
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.
Raghav Kapoor authoredBACKGROUND: 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