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

提交sql上线的时候,提示表的例里面内容不能为空,其实我们业务上设计是可以的 #651

Closed
firehalt opened this issue May 28, 2024 · 0 comments

Comments

@firehalt
Copy link

描述
提交sql上线的时候,提示表的例里面内容不能为空,其实我们业务上设计是可以的

重现
CREATE TABLE bi_forecasting_rr (
id bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
vc_code varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'vc账号编码',
asin varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品唯一标识',
product_title varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品名称',
brand varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '品牌',
upc varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品条形码upc',
ean varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品条形码ean',
data_date bigint DEFAULT NULL COMMENT '报表数据时间',
created_at bigint DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (id),
KEY product_title (product_title) USING BTREE,
KEY brand (brand) USING BTREE,
KEY upc (upc) USING BTREE,
KEY ean (ean) USING BTREE,
KEY asin (asin,vc_code) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='BI预测报表';

环境

  • 数据库: [mysqlb]
  • 版本: [例如 5.7.21]

错误
screenshot-20240528-121007

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

1 participant