actiontech / dtle

Distributed Data Transfer Service for MySQL
https://actiontech.github.io/dtle-docs-cn
Mozilla Public License 2.0
551 stars 132 forks source link

`lower_case_table_names=1` causes error #1036

Closed ghost closed 1 year ago

ghost commented 1 year ago
-- 修改my.cnf: lower_case_table_names=1
select @@lower_case_table_names;

create schema if not exists a1036;
use a1036;

drop table if exists AAA;
create table AAA (id int primary key auto_increment);
alter table AAA add column val int;
-- alter table 复制报错: table does not exist in sqle.context

现状

问题

修复

ghost commented 1 year ago

Case 2: LowerString(&TableSchemaRegex) 错误

例如\W->\w肯定不对.

ghost commented 1 year ago

Case 3: review the usage of the variable query8 in binlog_reader.go

asiroliu commented 1 year ago

新增自动化测试用例