Bug #96574 reorganize partition downcases table name on Mac OS X

• Submitted: 16 Aug 2019 17:21
• Modified: 19 Aug 2019 6:44
• Reporter: Alex Charis
• Status: Verified
• Category: MySQL Server: Partitions
• Severity: S2 (Serious)
• Version: 5.7.24, 5.7.27
• OS: Mac OS X
• CPU Architecture: Any

[16 Aug 2019 17:21] Alex Charis

Description:
On Mac OS X, executing a REORGANIZE PARTITION statement will change the name of the table to lowercase.

How to repeat:
Start mysql with lower_case_table_names = 2 on Mac OS X.

create database foo;
use foo;
create table camelCase (id int, data varchar(20));
alter table camelCase partition by range (id) (partition p0 values less than (0), partition p1 values less than (MAXVALUE));

show tables; -- observe the table is named camelCase

alter table camelCase reorganize partition p1 into (partition p1 values less than (1000), partition p2 values less than (MAXVALUE));

show tables; -- observe the table is now named camelcase

[19 Aug 2019 6:44] Umesh Shastry

Hello Alex Charis,

Thank you for the report and feedback.
Verified as described with 5.7.27 build.

regards,
Umesh