[Optimization] [CDCSOURCE] The database name contains a string - the entire database cannot be synchronized

[lliuql]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

What you expected to happen

带字符串-会导致同步不了。

How to reproduce

EXECUTE CDCSOURCE cdc_mysql WITH (
'connector' = 'mysql-cdc',
'hostname' = 'rm-xxxxxxxx',
'port' = '3306',
'username' = 'root',
'password' = 'xxx-xxxx',
'checkpoint' = '3000',
'scan.startup.mode' = 'initial',
'parallelism' = '1',
'database-name' = 'middle-platform',
'table-name' = 'middle-platform.blade_client,middle-platform.blade_dept',
'sink.connector' = 'jdbc',
'sink.url' = 'jdbc:mysql://120.0.0.1:3306/middle-platform?characterEncoding=utf-8&useSSL=false',
'sink.username' = 'root',
'sink.password' = 'x-x',
'sink.sink.db' = 'middle-platform',
'sink.table.prefix' = '',
'sink.table-name' = '#{tableName}',
'sink.driver' = 'com.mysql.cj.jdbc.Driver',
'sink.sink.buffer-flush.interval' = '2s',
'sink.sink.buffer-flush.max-rows' = '100',
'sink.sink.max-retries' = '5',
'sink.auto.create' = 'true'
)

Anything else

No response

Version

1.0.0

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[github-actions]

Hello @lliuql, this issue is about CDC/CDCSOURCE, so I assign it to @aiwenmo. If you have any questions, you can comment and reply.

你好 @lliuql, 这个 issue 是关于 CDC/CDCSOURCE 的，所以我把它分配给了 @aiwenmo。如有任何问题，可以评论回复。

[Zzm0809]

Perhaps you can do some compatibility processing at the code level when building the entire library to synchronize ddl, such as adding `` backticks.

[github-actions]

Hello @, this issue has not been active for more than 30 days. This issue will be closed in 7 days if there is no response. If you have any questions, you can comment and reply.

你好 @, 这个 issue 30 天内没有活跃，7 天后将关闭，如需回复，可以评论回复。