hanchuanchuan / goInception

一个集审核、执行、备份及生成回滚语句于一身的MySQL运维工具
https://hanchuanchuan.github.io/goInception/
GNU General Public License v3.0
1.6k stars 545 forks source link

DDL语句中出现特殊字符, 审核通过, 执行失败 #598

Closed xiaoshenwei closed 11 months ago

xiaoshenwei commented 11 months ago

描述 SQL语句中出现某些特殊字符

重现

CREATE TABLE `commodity_sku_sell_channel_sales` (
  `id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'id',
  `createTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `modifyTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `skuId` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'skuId',
  `sellChannel` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '销售渠道',
  `salesNum` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '销量',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_skuId_sellChannel` (`skuId`,`sellChannel`)
) DEFAULT CHARSET=utf8mb4 COMMENT='sku渠道销售信息'
image

环境

参数 可能与问题相关的设置参数

goInception 审核通过 但MySQL执行失败 image

hanchuanchuan commented 11 months ago

goinception未复现该问题, 请检查goinception日志来验证提交的SQL是否正确.