为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:centos7
【CPU】:
【问题描述】*:
试图修改自增列[f_sort]
表结构:
CREATE TABLE "product_v3"."t_page_category"
(
"f_code" VARCHAR(255) NOT NULL,
"f_id" BIGINT NOT NULL,
"f_parent_id" BIGINT DEFAULT NULL,
"f_full_id" VARCHAR(200) DEFAULT NULL,
"f_level" INT NOT NULL,
"f_is_leaf" BIT NOT NULL,
"f_name" VARCHAR(64) NOT NULL,
"f_description" VARCHAR(1024) DEFAULT NULL,
"f_product_code" VARCHAR(255) NOT NULL,
"f_sort" INT IDENTITY(25918, 1) NOT NULL,
"f_deleted" BIT NOT NULL,
"f_tenant_id" BIGINT DEFAULT NULL,
"f_create_time" DATETIME(0) DEFAULT NULL,
"f_update_time" DATETIME(0) DEFAULT NULL,
NOT CLUSTER PRIMARY KEY("f_id")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "product_v3"."t_page_category"."f_code" IS '模块Code';
COMMENT ON COLUMN "product_v3"."t_page_category"."f_create_time" IS '创建时间';
COMMENT ON COLUMN "product_v3"."t_page_category"."f_deleted" IS '是否删除 0否,1 是';
COMMENT ON COLUMN "product_v3"."t_page_category"."f_description" IS '模块描述';
COMMENT ON COLUMN "product_v3"."t_page_category"."f_full_id" IS 'ID全路径';
COMMENT ON COLUMN "product_v3"."t_page_category"."f_id" IS '模块id';
COMMENT ON COLUMN "product_v3"."t_page_category"."f_is_leaf" IS '是否叶子节点 0否 1是';
COMMENT ON COLUMN "product_v3"."t_page_category"."f_level" IS '节点级别 从1级开始';
COMMENT ON COLUMN "product_v3"."t_page_category"."f_name" IS '模块分类名称';
COMMENT ON COLUMN "product_v3"."t_page_category"."f_parent_id" IS '父节点ID';
COMMENT ON COLUMN "product_v3"."t_page_category"."f_product_code" IS '产品编码';
COMMENT ON COLUMN "product_v3"."t_page_category"."f_sort" IS '排序字段';
COMMENT ON COLUMN "product_v3"."t_page_category"."f_tenant_id" IS '租户ID';
COMMENT ON COLUMN "product_v3"."t_page_category"."f_update_time" IS '更新时间';
CREATE INDEX "t_page_category_idx_product_sort" ON "product_v3"."t_page_category"("f_sort" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE INDEX "t_page_category_idx_product_code" ON "product_v3"."t_page_category"("f_product_code" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
其中f_sort不是主键,但是是自增列,使用insert和update插入值和更新值都没问题,但是使用merge into去update f_sort的时候就会报这个错误。
设置
SET IDENTITY_INSERT product_v3.t_page_category on
后效果和off效果是一样的