Clickhose 插入可空 int32类型的时，提示无法 Value \N cannot be parsed 返回
会飞的大鸟 发布于1周前
Code: 457. DB::Exception: Value \N cannot be parsed as Int32 for query parameter 'DeleteUId' because it isn't parsed completely: only 0 of 2 bytes was parsed: : While executing ValuesBlockInputFormat. (BAD_QUERY_PARAMETER) (version 23.8.16.40 (official build))
热忱回答（11）
-
会飞的大鸟 VIP0
1周前
我建表是这样的0 回复 -
fate sta VIP0
1周前应该是有特殊数据
\N
0 回复 -
fate sta VIP0
1周前
检查表里面的数据。
0 回复 -
会飞的大鸟 VIP0
1周前
@fate sta：我是新建的表，我检查了对象，字段给的null，我检查了 OnLogExecuting 中的 pars，看到的 value 值也是 null
0 回复 -
会飞的大鸟 VIP0
1周前
@fate sta：这是我打印的 sql和参数
INSERT INTO "b30_RebateAgreement"
("Id","Number","Name","VenderId","VenderName","SignTime","EndTime","Type","Stage","BuyerContacts","SellerContacts","BuyerPhone","SellerPhone","FileNumber","Remark","CreateTime","CreateSUId","CreateUId","AuditState","AuditStateStatge","IsDelete","DeleteTime","DeleteUId","DeleteSUId","SellerErpId","EditNumber","UpdateTime","RichText","BuyerId","AbolishAuditState","InDepartmentId","InDepartmentName","AuditTakeEffectTime","CreateType")
VALUES
(@Id,@Number,@Name,@VenderId,@VenderName,@SignTime,@EndTime,@Type,@Stage,@BuyerContacts,@SellerContacts,@BuyerPhone,@SellerPhone,@FileNumber,@Remark,@CreateTime,@CreateSUId,@CreateUId,@AuditState,@AuditStateStatge,@IsDelete,@DeleteTime,@DeleteUId,@DeleteSUId,@SellerErpId,@EditNumber,@UpdateTime,@RichText,@BuyerId,@AbolishAuditState,@InDepartmentId,@InDepartmentName,@AuditTakeEffectTime,@CreateType) ;
参数：
{"@Id":9081,"@Number":"23042004067014","@Name":"测试1111","@VenderId":2207,"@VenderName":"一医药有限公司(普药组)","@SignTime":"2023-04-20T00:00:00","@EndTime":"2023-04-23T00:00:00","@Type":0,"@Stage":0,"@BuyerContacts":"","@SellerContacts":"17381114890","@BuyerPhone":"","@SellerPhone":"","@FileNumber":"","@Remark":"","@CreateTime":"2023-04-20T18:32:52.553","@CreateSUId":183,"@CreateUId":4067,"@AuditState":2,"@AuditStateStatge":0,"@IsDelete":false,"@DeleteTime":null,"@DeleteUId":null,"@DeleteSUId":null,"@SellerErpId":"1212","@EditNumber":0,"@UpdateTime":"2023-04-20T18:33:08.817","@RichText":"<p><br></p>","@BuyerId":3105,"@AbolishAuditState":0,"@InDepartmentId":0,"@InDepartmentName":null,"@AuditTakeEffectTime":"2023-04-20T18:37:56.727","@CreateType":1}
0 回复 -
会飞的大鸟 VIP0
1周前
@会飞的大鸟：显示的没有换行，后面被隐藏了，按F12 看看吧
0 回复 -
会飞的大鸟 VIP0
1周前
@fate sta：SqlSugar.ClickHouseCore 5.1.4.199
0 回复 -
会飞的大鸟 VIP0
1周前
我加了 .IgnoreColumnsNull() ，把空值忽略了，这样是可以了，但是我提的问题还是没有解决
0 回复 -
fate sta VIP0
1周前
你说的是插入是吗，我看一下。
0 回复 -
会飞的大鸟 VIP0
1周前
@fate sta：就是插入数据
0 回复 -
会飞的大鸟 VIP0
6天前
@fate sta：我用 IgnoreColumnsNull() 这个，无法使用批量插入，还是要解决这个问题才行
0 回复