人大金仓 Mysql模式下Guid查询问题 返回

SqlSugar 沟通中
10 933
该叫什么 xyzz 发布于2025/12/29
悬赏:0 飞吻

人大金仓:

模式: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");


最终表结构:


Snipaste_2025-12-29_15-50-27.png

请问大佬这是什么问题,感谢

热忱回答(10)

  • fate sta fate sta VIP0
    2025/12/29

    实体应该用guid类型。

    0 回复
  • fate sta fate sta VIP0
    2025/12/29

    这个错是你传的参数是字符串类型

    0 回复
  • fate sta fate sta VIP0
    2025/12/29

      "areaid" uuid

    或者将建表语句中的uuid改成varchar。

    0 回复
  • xyzz xyzz VIP0
    2025/12/29

    @fate sta:我实体和变量 AreaId areaId这两个,都是guid类型

    0 回复
  • xyzz 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 fate sta VIP0
    2025/12/30

    mysql可能不支持uuid类型。

    0 回复
  • fate sta fate sta VIP0
    2025/12/30

    改成char(36) 看看

    0 回复
  • fate sta fate sta VIP0
    2025/12/30

    表重建一下。

    0 回复
  • xyzz 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 xyzz VIP0
    2025/12/30

    解决了,最终还是用的PostgreSQL连接,然后把 timestamp(6) 改成  timestamp without time zone,就正常了


    0 回复