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 Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Partitions Severity:S2 (Serious)
Version:5.7.24, 5.7.27 OS:MacOS
Assigned to: CPU Architecture:Any

[16 Aug 2019 17:21] Alex Charis
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] MySQL Verification Team
Hello Alex Charis,

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