为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:docker debain
【CPU】:x86_64
【问题描述】*:表
CREATE TABLE "PHEE"."task_queue"
(
"id" INT IDENTITY(1, 1) NOT NULL,
"_id" VARCHAR2(128) DEFAULT '' NOT NULL,
"enterprise_id" VARCHAR2(24) DEFAULT '' NOT NULL,
"controller" VARCHAR2(60) DEFAULT '' NOT NULL,
"function" VARCHAR2(60) DEFAULT '' NOT NULL,
"caller" VARCHAR2(255) DEFAULT '' NOT NULL,
"status" NUMBER(11,0) DEFAULT 0 NOT NULL,
"params" JSONB DEFAULT NULL,
"create_time" DATETIME(0) DEFAULT NULL,
"update_time" DATETIME(0) DEFAULT NULL,
"expire" NUMBER(11,0) DEFAULT 0,
"memo" JSONB DEFAULT NULL,
"output" JSONB DEFAULT NULL,
NOT CLUSTER PRIMARY KEY("id")) STORAGE(ON "MAIN", CLUSTERBTR);
CREATE OR REPLACE INDEX "PHEE"."task_queue__id" ON "PHEE"."task_queue"("_id" ASC) STORAGE(ON "MAIN", CLUSTERBTR);
CREATE OR REPLACE INDEX "PHEE"."task_queue_enterprise_id" ON "PHEE"."task_queue"("enterprise_id" ASC) STORAGE(ON "MAIN", CLUSTERBTR);
CREATE OR REPLACE INDEX "PHEE"."task_queue_controller" ON "PHEE"."task_queue"("controller" ASC) STORAGE(ON "MAIN", CLUSTERBTR);
CREATE OR REPLACE INDEX "PHEE"."task_queue_function" ON "PHEE"."task_queue"("function" ASC) STORAGE(ON "MAIN", CLUSTERBTR);
CREATE OR REPLACE INDEX "PHEE"."task_queue_status" ON "PHEE"."task_queue"("status" ASC) STORAGE(ON "MAIN", CLUSTERBTR);
CREATE OR REPLACE INDEX "PHEE"."task_queue_create_time" ON "PHEE"."task_queue"("create_time" ASC) STORAGE(ON "MAIN", CLUSTERBTR);
CREATE OR REPLACE INDEX "PHEE"."task_queue_update_time" ON "PHEE"."task_queue"("update_time" ASC) STORAGE(ON "MAIN", CLUSTERBTR);
COMMENT ON TABLE "PHEE"."task_queue" IS '任务队列';
COMMENT ON COLUMN "PHEE"."task_queue"."_id" IS '兼容mongodb的字段';
COMMENT ON COLUMN "PHEE"."task_queue"."enterprise_id" IS '企业ID';
COMMENT ON COLUMN "PHEE"."task_queue"."controller" IS 'controller';
COMMENT ON COLUMN "PHEE"."task_queue"."function" IS 'function';
COMMENT ON COLUMN "PHEE"."task_queue"."caller" IS 'caller';
COMMENT ON COLUMN "PHEE"."task_queue"."status" IS 'status';
COMMENT ON COLUMN "PHEE"."task_queue"."params" IS 'params';
COMMENT ON COLUMN "PHEE"."task_queue"."create_time" IS '创建时间';
COMMENT ON COLUMN "PHEE"."task_queue"."update_time" IS '更新时间';
COMMENT ON COLUMN "PHEE"."task_queue"."expire" IS '超时时间';
COMMENT ON COLUMN "PHEE"."task_queue"."memo" IS 'memo';
COMMENT ON COLUMN "PHEE"."task_queue"."output" IS 'output';
使用语句插入数据成功后,其他有值,但params 字段的值是 null
INSERT INTO "task_queue" ("enterprise_id", "controller", "function", "caller", "params", "_id", "status", "create_time", "memo", "output") VALUES ('68a6cbf42be0445b156fa922', 'test1', 'test1', 'test', '{"test1":1}', '68f620e898f5ba012bfaab27', 0, '2025-10-20 11:45:44', 'null', 'null')

麻烦再提供以下信息:

1.数据库版本信息,如下图
select * from v$version;
2.数据库配置文件
再数据目录下的dm.ini文件