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

timestamp default 使用utc_timestamp审核不通过 #653

Open
Asa6 opened this issue Jun 5, 2024 · 2 comments
Open

timestamp default 使用utc_timestamp审核不通过 #653

Asa6 opened this issue Jun 5, 2024 · 2 comments

Comments

@Asa6
Copy link

Asa6 commented Jun 5, 2024

CREATE TABLE t_tenant (
id int NOT NULL AUTO_INCREMENT COMMENT 'id',
create_user_id int NOT NULL DEFAULT '0' COMMENT '创建人',
update_time datetime NOT NULL DEFAULT (utc_timestamp) COMMENT '更新时间',
PRIMARY KEY (id),
UNIQUE KEY check_tenant_code (tenant_code) COMMENT '租户编码唯一'
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='租户';

mysql实际支持,goinception这里并不支持
报错 表定义不正确,使用utc_timestamp设置默认值时无法审核通过.

重现
模拟重现的步骤

环境

数据库: mysql
版本: 8.0
参数
可能与问题相关的设置参数

@zmix999
Copy link
Contributor

zmix999 commented Jun 5, 2024

得等主分支修复了,可以看下我的分支https://gitee.com/zhoujin826/goInception

@Asa6
Copy link
Author

Asa6 commented Jun 6, 2024

得主分支修复了,可以看下我的分支https://gitee.com/zhoujin826/goInception

好的,非常感谢,我下载安装一下

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