注册

无效的表或视图

DM_515915 2025/01/09 484 7

【DM版本】:8
【操作系统】:centos
【问题描述】*:
执行建表语句:

CREATE TABLE "TESTSY"."SYS_TEN"
(
"ID" BIGINT AUTO_INCREMENT NOT NULL,
"NAME" VARCHAR(384) NOT NULL,
"TENANT_CODE" VARCHAR(192) DEFAULT '' NOT NULL,
"PROPS" TEXT NOT NULL,
"CREATE_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL,
"CREATOR_ID" DECIMAL(20,0) NOT NULL,
"UPDATE_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL,
"UPDATER_ID" DECIMAL(20,0) NOT NULL,
"VALID_FLAG" TINYINT DEFAULT 1 NOT NULL,
"CREATOR" VARCHAR(192) DEFAULT '' NOT NULL,
"UPDATER" VARCHAR(192) DEFAULT '' NOT NULL,
NOT CLUSTER PRIMARY KEY("ID"),
CHECK("CREATOR_ID" >= 0)
,CHECK("UPDATER_ID" >= 0)) STORAGE(ON "MAIN", CLUSTERBTR) AUTO_INCREMENT = 1488504

建表创建成功后,立即执行insert语句:

INSERT INTO "TESTSY"."SYS_TEN"("ID", "NAME", "TENANT_CODE", "PROPS", "CREATE_TIME", "CREATOR_ID", "UPDATE_TIME", "UPDATER_ID", "VALID_FLAG", "CREATOR", "UPDATER") VALUES(2, '管理员_99', 'Code_6', '{''sysName'':''系统'',''srcType'':''fusionSystem''}', TIMESTAMP'2025-01-08 11:14:51', 1274, TIMESTAMP'2025-01-08 11:14:56', 1923, 6, 'creator_9394', 'updater_3517')

报错:
无效的表或视图名[SYS_TEN]

请问这是什么问题?

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