MySQL-MySQL: src MySQL @@lctn=1 and dest MySQL @@lctn=0， `ALTER TABLE RENAME` did not match expectations

[asiroliu]

Description

MySQL-MySQL: src MySQL @@lctn=1 and dest MySQL 源端@@lctn=0， ALTER TABLE RENAME did not match expectations

Steps to reproduce the issue

1. src MySQL lower_case_table_names=1, dest MySQl lower_case_table_names=0
2. create dtle job
3. execute sql on src Mysql

create table test.A(id int(11)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
alter table test.A rename to test.B;

4. check dest MySQL general log

2023-03-03T02:47:43.161554Z	    9 Query	show create table a
2023-03-03T02:48:36.854325Z	    5 Query	ALTER TABLE `test`.`a` RENAME AS `test`.`B` /*dtle_gtid1 s1d0-migration 5704c1fa-b96b-11ed-8fc2-0242ac640901 11 dtle_gtid*/
2023-03-03T02:48:36.855969Z	    5 Execute	replace into dtle.gtid_executed_v4 (job_name,source_uuid,gtid,gtid_set) values (?, ?, ?, null)
2023-03-03T02:48:36.856483Z	    5 Query	commit

5. check dest MySQL table

mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| B              |
+----------------+
1 row in set (0.00 sec)

Describe the results you expected

the dest MySQL should rename to lower case table name test.b

Output of ./dtle version:**

9.9.9.9-master-9e5c3f7