dinky icon indicating copy to clipboard operation
dinky copied to clipboard

[Bug] [MySQL whole library synchronization] MySQL whole library is synchronized to MySQL. When generating CreateCreateTableSql, the functions in MySQL are added with single quotes.

Open wangxinyii opened this issue 4 months ago • 2 comments

Search before asking

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

What happened

MySQL 整库同步到 MySQL,generateCreateTableSql 时 MySQL 中自带的函数多加了单引号,导致创建表失败

Image

What you expected to happen

去掉函数的单引号

How to reproduce

创建表时添加时间字段并配置默认值为 CURRENT_TIMESTAMP

CREATE TABLE IF NOT EXISTS `test_db`.`user` (
  `user_eid`  int(10) unsigned NOT  NULL  AUTO_INCREMENT ,
  `crt_time`  datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`user_eid`)
)
 ENGINE=InnoDB row_format=DYNAMIC;

使用 dinky 整库同步功能,MySQL 同步至 MySQL

Anything else

No response

Version

1.2.0

Are you willing to submit PR?

  • [ ] Yes I am willing to submit a PR!

Code of Conduct

wangxinyii avatar Aug 01 '25 06:08 wangxinyii

Upgrade to version 1.2.4, or modify the source code of version 1.0.3 by yourself and then compile it.

aiwenmo avatar Aug 04 '25 01:08 aiwenmo

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

github-actions[bot] avatar Oct 01 '25 00:10 github-actions[bot]