Backup Snapshot Fails Due to Case-Insensitive Table Name Handling: Duplicated Table Error

[fixpng]

Steps to reproduce the behavior (Required)

USE test;

CREATE TABLE `dws_hrm_hyyg_sumday` (
  `company_name` varchar(65533) NULL COMMENT "企业名称",
  `create_time_day` date NULL COMMENT "当前时间",
  `active_staff` int(11) NULL COMMENT "活跃员工数",
  `month_active_staff` int(11) NULL COMMENT "月活跃员工数",
  `etl_time` varchar(65533) NULL COMMENT "ETL时间",
  `data_dt` varchar(65533) NULL COMMENT ""
) ENGINE=OLAP 
DUPLICATE KEY(`company_name`)
COMMENT "活跃员工数日汇总表"
DISTRIBUTED BY HASH(`company_name`) BUCKETS 8 
PROPERTIES (
"replication_num" = "3",
"in_memory" = "false",
"storage_format" = "DEFAULT",
"enable_persistent_index" = "false",
"compression" = "LZ4"
);

CREATE TABLE `dws_hrm_hyyg_sumDay` (
  `company_name` varchar(65533) NULL COMMENT "企业名称",
  `create_time_day` date NULL COMMENT "当前时间",
  `active_staff` int(11) NULL COMMENT "活跃员工数",
  `month_active_staff` int(11) NULL COMMENT "月活跃员工数",
  `etl_time` varchar(65533) NULL COMMENT "ETL时间",
  `data_dt` varchar(65533) NULL COMMENT ""
) ENGINE=OLAP 
DUPLICATE KEY(`company_name`)
COMMENT "活跃员工数日汇总表"
DISTRIBUTED BY HASH(`company_name`) BUCKETS 8 
PROPERTIES (
"replication_num" = "3",
"in_memory" = "false",
"storage_format" = "DEFAULT",
"enable_persistent_index" = "false",
"compression" = "LZ4"
);

BACKUP SNAPSHOT test.test_20250218111839_backup  TO uat_backup_repo ON (`dws_hrm_hyyg_sumday`,`dws_hrm_hyyg_sumDay`);

Expected behavior (Required)

When table names are identical but differ in case, they should be recognized as two separate tables and backed up individually.

Real behavior (Required)

pymysql.err.ProgrammingError: (1064, 'Duplicated table: dws_hrm_hyyg_sumDay')

StarRocks version (Required)

• 2.5.21 dc2bcdb
• 3.2.9-63ce1bd

[rohitrs1983]

#51068