doris数据库，配置DisableNvarchar = true，生成的sql依旧带N 返回

睿小智 发布于2026/8/12

悬赏：0 飞吻

收藏

热忱回答（7）

• fate sta VIP0

  2026/8/12

   Console.WriteLine(UtilMethods.GetNativeSql(sql, pars));

  用这个打印，你这个SQL打印不准

  
  

  0 回复
• 睿小智 VIP0

  1个月前

  exMessage：errCode = 2, detailMessage = Insert has filtered data in strict mode. url: http://192.168.12.12:8040/api/_load_error_log?file=__shard_176/error_log_insert_stmt_c8f63d18ffcf4e2e-a9e2c812ee5e7e29_c8f63d18ffcf4e2e_a9e2c812ee5e7e29

  
  

  
  

  exStackTrace：在 SqlSugar.MySqlProvider.<ExecuteCommandAsync>d__12.MoveNext()

     在 SqlSugar.MySqlProvider.<ExecuteCommandAsync>d__12.MoveNext()

     在 SqlSugar.InsertableProvider`1.<ExecuteCommandAsync>d__105.MoveNext()

     在 LGMG_DataApi.Services.DorisSyncService.<SyncAsync>d__4`1.MoveNext() 在 D:\数企智能\任务需求\临工重机20260801\Code\NewCode\LGMG-DataApi\LGMG-DataApi\Services\DorisSyncService.cs 中: 第 76 行

     

  打印的sql: INSERT INTO `ARPublic`

             (`Id`,`IssueNo`,`BillDate`,`BodyId`,`HeadId`,`Code`,`FinanceOrg`,`FinanceOrgCode`,`FinanceOrgName`,`AccPeriod`,`AccPeriodCode`,`AccPeriodName`,`Customer`,`CustomerCode`,`CustomerName`,`SrcBillType`,`SrcBillTypeCode`,`SrcBillTypeName`,`SrcBillId`,`SrcBillCode`,`BizBillType`,`BizBillTypeCode`,`BizBillTypeName`,`BizBillCode`,`BizBillId`,`Voucher`,`IncomeSubject`,`IncomeSubjectCode`,`IncomeSubjectName`,`VoucherCode`,`OriBillNo`,`OriBillRowId`,`OriBillType`,`OriBillTypeCode`,`OriBillTypeName`,`SrcBillRowId`,`Material`,`MaterialCode`,`MaterialName`,`AdvanceBillFlag`,`OriCurrency`,`OriCurrencyCode`,`OriCurrencyName`,`OriTaxExcludedAmount`,`AccTaxExcludedAmount`,`OriTaxIncludedAmount`,`ExpireDate`,`StartDate`,`ArapEventType`,`IsDel`,`AccAmount`,`OriAmount`,`SrcOrderRowId`,`AccCurrency`,`AccCurrencyCode`,`AccCurrencyName`)

       VALUES

             (@Id,@IssueNo,@BillDate,@BodyId,@HeadId,@Code,@FinanceOrg,@FinanceOrgCode,@FinanceOrgName,@AccPeriod,@AccPeriodCode,@AccPeriodName,@Customer,@CustomerCode,@CustomerName,@SrcBillType,@SrcBillTypeCode,@SrcBillTypeName,@SrcBillId,@SrcBillCode,@BizBillType,@BizBillTypeCode,@BizBillTypeName,@BizBillCode,@BizBillId,@Voucher,@IncomeSubject,@IncomeSubjectCode,@IncomeSubjectName,@VoucherCode,@OriBillNo,@OriBillRowId,@OriBillType,@OriBillTypeCode,@OriBillTypeName,@SrcBillRowId,@Material,@MaterialCode,@MaterialName,@AdvanceBillFlag,@OriCurrency,@OriCurrencyCode,@OriCurrencyName,@OriTaxExcludedAmount,@AccTaxExcludedAmount,@OriTaxIncludedAmount,@ExpireDate,@StartDate,@ArapEventType,@IsDel,@AccAmount,@OriAmount,@SrcOrderRowId,@AccCurrency,@AccCurrencyCode,@AccCurrencyName) ;

  [Pars]:

  [Name]:@Id [Value]:2032426010688880653 [Type]:String

  [Name]:@IssueNo [Value]: [Type]:String

  [Name]:@BillDate [Value]:2024/4/30 00:00:00 [Type]:DateTime

  [Name]:@BodyId [Value]:2032426010688880649 [Type]:String

  [Name]:@HeadId [Value]:2009659849348481035 [Type]:String

  [Name]:@Code [Value]:AR02240430000001 [Type]:String

  [Name]:@FinanceOrg [Value]:1954448190766841860 [Type]:String

  [Name]:@FinanceOrgCode [Value]:01 [Type]:String

  [Name]:@FinanceOrgName [Value]:中租益联建筑工程有限公司 [Type]:String

  [Name]:@AccPeriod [Value]:1851309799606583309 [Type]:String

  [Name]:@AccPeriodCode [Value]:2024-05 [Type]:String

  [Name]:@AccPeriodName [Value]:2024-05 [Type]:String

  [Name]:@Customer [Value]:1975599805205839879 [Type]:String

  [Name]:@CustomerCode [Value]:2377 [Type]:String

  [Name]:@CustomerName [Value]:山东高强紧固件有限公司 [Type]:String

  [Name]:@SrcBillType [Value]: [Type]:String

  [Name]:@SrcBillTypeCode [Value]: [Type]:String

  [Name]:@SrcBillTypeName [Value]: [Type]:String

  [Name]:@SrcBillId [Value]: [Type]:String

  [Name]:@SrcBillCode [Value]:AR02240430000001 [Type]:String

  [Name]:@BizBillType [Value]: [Type]:String

  [Name]:@BizBillTypeCode [Value]: [Type]:String

  [Name]:@BizBillTypeName [Value]: [Type]:String

  [Name]:@BizBillCode [Value]:AR02240430000001 [Type]:String

  [Name]:@BizBillId [Value]: [Type]:String

  [Name]:@Voucher [Value]: [Type]:String

  [Name]:@IncomeSubject [Value]: [Type]:String

  [Name]:@IncomeSubjectCode [Value]: [Type]:String

  [Name]:@IncomeSubjectName [Value]: [Type]:String

  [Name]:@VoucherCode [Value]: [Type]:String

  [Name]:@OriBillNo [Value]: [Type]:String

  [Name]:@OriBillRowId [Value]: [Type]:String

  [Name]:@OriBillType [Value]: [Type]:String

  [Name]:@OriBillTypeCode [Value]: [Type]:String

  [Name]:@OriBillTypeName [Value]: [Type]:String

  [Name]:@SrcBillRowId [Value]: [Type]:String

  [Name]:@Material [Value]: [Type]:String

  [Name]:@MaterialCode [Value]: [Type]:String

  [Name]:@MaterialName [Value]: [Type]:String

  [Name]:@AdvanceBillFlag [Value]: [Type]:String

  [Name]:@OriCurrency [Value]:1815814927148386539 [Type]:String

  [Name]:@OriCurrencyCode [Value]:CNY [Type]:String

  [Name]:@OriCurrencyName [Value]:人民币 [Type]:String

  [Name]:@OriTaxExcludedAmount [Value]:-142088.5 [Type]:Decimal

  [Name]:@AccTaxExcludedAmount [Value]:-142088.5 [Type]:Decimal

  [Name]:@OriTaxIncludedAmount [Value]:-160560 [Type]:Decimal

  [Name]:@ExpireDate [Value]:9999/12/31 00:00:00 [Type]:DateTime

  [Name]:@StartDate [Value]:2024/4/30 00:00:00 [Type]:DateTime

  [Name]:@ArapEventType [Value]:103 [Type]:Int32

  [Name]:@IsDel [Value]:0 [Type]:Int32

  [Name]:@AccAmount [Value]:-160560 [Type]:Decimal

  [Name]:@OriAmount [Value]:-160560 [Type]:Decimal

  [Name]:@SrcOrderRowId [Value]: [Type]:String

  [Name]:@AccCurrency [Value]:1815814927148386539 [Type]:String

  [Name]:@AccCurrencyCode [Value]:CNY [Type]:String

  [Name]:@AccCurrencyName [Value]:人民币 [Type]:String

  
  

  实体类：

  

  0 回复
• fate sta VIP0

  1个月前

   SqlSugarCore5.1.4.217-preview01

   已修复

  0 回复
• fate sta VIP0

  1个月前

  更新到预览版本

  0 回复
• 睿小智 VIP0

  1个月前

  能告知具体什么原因吗？

  
  

  0 回复
• 睿小智 VIP0

  1个月前

  我也学习下

  0 回复
• fate sta VIP0

  1个月前

  @睿小智：单条插入没处理，因为正常情况下能插入就可以了。 不像更新查询会有索引失效问题，可能个别版本的数据不支持写入。

  0 回复