dinky
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.
Search before asking
- [x] I had searched in the issues and found no similar issues.
What happened
MySQL 整库同步到 MySQL,generateCreateTableSql 时 MySQL 中自带的函数多加了单引号,导致创建表失败
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
- [x] I agree to follow this project's Code of Conduct
Upgrade to version 1.2.4, or modify the source code of version 1.0.3 by yourself and then compile it.
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 天后将关闭,如需回复,可以评论回复。