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

[lliuql]

Search before asking

• [X] 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

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

[github-actions[bot]]

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[bot]]

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 天后将关闭，如需回复，可以评论回复。