Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
xiaoshenwei opened this issue Aug 10, 2023 · 1 comment
Closed

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

xiaoshenwei opened this issue Aug 10, 2023 · 1 comment

Comments

@xiaoshenwei
Copy link

描述
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

环境

  • 数据库: [mysql/mariadb]
  • 版本: [例如 5.7.21]

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

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

@xiaoshenwei xiaoshenwei changed the title SQL审核出现特殊字符 DDL语句中出现特殊字符, 审核通过, 执行失败 Aug 10, 2023
@hanchuanchuan
Copy link
Owner

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants