注册

且SET IDENTITY_INSERT为ON时,才能对自增列赋值

lansan 2023/07/18 3016 14

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:centos
【CPU】:x86
【问题描述】*:
mysql 迁移过来,主键自增,执行出现异常,有什么好的解决方案不:
Error updating database. Cause: dm.jdbc.driver.DMException: 仅当指定列列表,且SET IDENTITY_INSERT为ON时,才能对自增列赋值

表结构:
CREATE TABLE "PRIVACY_DETECTION"."TSYS_USER_LOGIN_LOG"
(
"LOG_ID" BIGINT IDENTITY(1, 1) NOT NULL,
"USER_ID" BIGINT,
"LOGIN_TIME" TIMESTAMP(0),
"LOGIN_MSG" VARCHAR(255),
"LOGIN_STATUS" INT,
"VALID_STATUS" INT,
NOT CLUSTER PRIMARY KEY("LOG_ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

COMMENT ON TABLE "PRIVACY_DETECTION"."TSYS_USER_LOGIN_LOG" IS '【可清理】登录日志';
COMMENT ON COLUMN "PRIVACY_DETECTION"."TSYS_USER_LOGIN_LOG"."LOGIN_MSG" IS '登录信息';
COMMENT ON COLUMN "PRIVACY_DETECTION"."TSYS_USER_LOGIN_LOG"."LOGIN_STATUS" IS '登录状态;1=成功,2=失败';
COMMENT ON COLUMN "PRIVACY_DETECTION"."TSYS_USER_LOGIN_LOG"."LOGIN_TIME" IS '登录时间';
COMMENT ON COLUMN "PRIVACY_DETECTION"."TSYS_USER_LOGIN_LOG"."LOG_ID" IS '日志ID';
COMMENT ON COLUMN "PRIVACY_DETECTION"."TSYS_USER_LOGIN_LOG"."USER_ID" IS '用户ID';
COMMENT ON COLUMN "PRIVACY_DE

回答 0
暂无回答
扫一扫
联系客服