人大金仓 Mysql模式下Guid查询问题 返回
xyzz 发布于2025/12/29
人大金仓:
模式:Mysql
版本:KingbaseES V009R001C002B0014 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit
连接方式:Kdbndp,MySql模式
SqlsugarCore:5.1.4.211
SqlSugarCore.Kdbndp:9.3.7.1219
异常提示:
Kdbndp.KingbaseException (0x80004005): 42883: operator does not exist: uuid = bpchar
at Kdbndp.KdbndpConnector.<>c__DisplayClass168_0.<<ReadMessage>g__ReadMessageLong|0>d.MoveNext()
--- End of stack trace from previous location ---
at Kdbndp.KdbndpConnector.<>c__DisplayClass168_0.<<ReadMessage>g__ReadMessageLong|0>d.MoveNext()
--- End of stack trace from previous location ---
at Kdbndp.KdbndpDataReader.NextResult(Boolean async, Boolean isConsuming)
at Kdbndp.KdbndpCommand.ExecuteDbDataReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
at SqlSugar.AdoProvider.GetDataReaderAsync(String sql, SugarParameter[] parameters)
at SqlSugar.QueryableProvider`1.GetDataAsync[TResult](KeyValuePair`2 sqlObj)
at SqlSugar.QueryableProvider`1._ToListAsync[TResult]()
异常代码:
var syncList = await _syncRep.AsQueryable().Filter(null, true)
.OrderBy(m => m.CreateTime)
.Where(m => m.Type == "D" && !m.IsDelete && m.AreaId == areaId)
.Take(100)
.ToListAsync();
m.AreaId 和 areaId 都是Guid类型
产出的SQL语句:
SELECT "TABLENAME","DATA","OPERATION","ISSYNC","TYPE","AREAID","TENANTID","CREATETIME","UPDATETIME","CREATEUSERID","UPDATEUSERID","ISDELETE","ID" FROM "SYNC" WHERE ((( "TYPE" = N'D' ) AND NOT ( "ISDELETE"=true ) ) AND ( "AREAID" = N'a85dc482-2015-432b-bbb4-daca05e7c6c1' )) ORDER BY "CREATETIME" ASC LIMIT 100 offset 0
使用SQL建表:
-- ----------------------------
-- Table structure for sync
-- ----------------------------
DROP TABLE IF EXISTS "public"."sync";
CREATE TABLE "public"."sync" (
"id" int8 NOT NULL,
"tablename" varchar(255) COLLATE "pg_catalog"."default" DEFAULT NULL::character varying,
"data" text COLLATE "pg_catalog"."default",
"tenantid" int8,
"createtime" timestamp(6),
"updatetime" timestamp(6),
"createuserid" int8,
"updateuserid" int8,
"isdelete" bool NOT NULL,
"operation" varchar(255) COLLATE "pg_catalog"."default" NOT NULL DEFAULT NULL::character varying,
"issync" bool NOT NULL,
"type" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
"areaid" uuid
)
;
COMMENT ON COLUMN "public"."sync"."id" IS 'Id';
COMMENT ON COLUMN "public"."sync"."tablename" IS '表名';
COMMENT ON COLUMN "public"."sync"."data" IS '数据';
COMMENT ON COLUMN "public"."sync"."tenantid" IS '租户Id';
COMMENT ON COLUMN "public"."sync"."createtime" IS '创建时间';
COMMENT ON COLUMN "public"."sync"."updatetime" IS '更新时间';
COMMENT ON COLUMN "public"."sync"."createuserid" IS '创建者Id';
COMMENT ON COLUMN "public"."sync"."updateuserid" IS '修改者Id';
COMMENT ON COLUMN "public"."sync"."isdelete" IS '软删除';
COMMENT ON COLUMN "public"."sync"."operation" IS '操作类型 C增加U修改D删除';
COMMENT ON COLUMN "public"."sync"."issync" IS '是否已经同步';
COMMENT ON COLUMN "public"."sync"."type" IS 'U上传到本项目 D下载到其它项目';
COMMENT ON COLUMN "public"."sync"."areaid" IS '区域id';
COMMENT ON TABLE "public"."sync" IS '同步表';
-- ----------------------------
-- Indexes structure for table sync
-- ----------------------------
CREATE INDEX "index_type" ON "public"."sync" USING btree (
"type" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
-- ----------------------------
-- Primary Key structure for table sync
-- ----------------------------
ALTER TABLE "public"."sync" ADD CONSTRAINT "sync_pkey" PRIMARY KEY ("id");
最终表结构:

请问大佬这是什么问题,感谢
热忱回答(10)
-
fate sta VIP0
2025/12/29实体应该用guid类型。
0 回复 -
fate sta VIP0
2025/12/29这个错是你传的参数是字符串类型
0 回复 -
fate sta VIP0
2025/12/29"areaid" uuid
或者将建表语句中的uuid改成varchar。
0 回复 -
xyzz VIP0
2025/12/29@fate sta:我实体和变量 AreaId areaId这两个,都是guid类型
0 回复 -
xyzz VIP0
2025/12/29/// <summary>
/// 同步记录
/// </summary>
[SugarTable(TableDescription = "同步表")]
public class Sync : EntityTenant
{
/// <summary>
/// 表名
/// </summary>
[SugarColumn(ColumnDescription = "表名")]
public string? TableName { get; set; }
/// <summary>
/// 同步数据
/// </summary>
[SugarColumn(ColumnDescription = "数据", ColumnDataType = StaticConfig.CodeFirst_BigString)]
public string? Data { get; set; }
/// <summary>
/// 操作类型 CUD
/// </summary>
[SugarColumn(ColumnDescription = "操作类型 C增加U修改D删除")]
public string Operation { get; set; }
/// <summary>
/// 是否已经同步
/// </summary>
[SugarColumn(ColumnDescription = "是否已经同步")]
public bool IsSync { get; set; } = false;
/// <summary>
/// U上传到本项目 D下载到其它项目
/// </summary>
[SugarColumn(ColumnDescription = "U上传到本项目 D下载到其它项目")]
public string Type { get; set; } = "D";
/// <summary>
/// 区域id
/// </summary>
[SugarColumn(ColumnDescription = "区域id")]
public Guid? AreaId { get; set; }
}
0 回复 -
fate sta VIP0
2025/12/30mysql可能不支持uuid类型。
0 回复 -
fate sta VIP0
2025/12/30改成char(36) 看看
0 回复 -
fate sta VIP0
2025/12/30表重建一下。
0 回复 -
xyzz VIP0
2025/12/30有点奇怪,我使用PostgreSQL数据库,生成的SQL语句是:SELECT "tablename","data","operation","issync","type","areaid","tenantid","createtime","updatetime","createuserid","updateuserid","isdelete","id" FROM "sync" WHERE ((( "type" = N'D' ) AND NOT ( "isdelete"=true ) ) AND ( "areaid" = CAST('a85dc482-2015-432b-bbb4-daca05e7c6c1' AS uuid) )) ORDER BY "createtime" ASC LIMIT 100 offset 0
0 回复 -
xyzz VIP0
2025/12/30解决了,最终还是用的PostgreSQL连接,然后把 timestamp(6) 改成 timestamp without time zone,就正常了
0 回复