5.1.4.202版本 list.any 中有null值时会报列名'Nnull'无效 返回

hp9999 发布于2025/9/24

悬赏：0 飞吻

收藏

热忱回答（7）

• fate sta VIP0

  2025/9/25

  AOP看一下SQL ，2次差异在哪儿

  0 回复
• hp9999 VIP0

  2025/9/25

  202版本
  SELECT  [source_bill_type] AS [SourceBillType] , [source_bill_no] AS [SourceBillNo] , [source_bill_serial] AS [SourceBillSerial] , SUM(ISNULL([generated_qty],0)) AS [Qty]  FROM [barcode] [it] WITH(NOLOCK)   WHERE  ( ((( Nnull = [it].[source_bill_type] ) AND ( Nnull = [it].[source_bill_no] )) AND ( Nnull = [it].[source_bill_serial] )) ) GROUP BY [source_bill_type],[source_bill_no],[source_bill_serial] ”

  生成的语句中 有Nnull = [it].[source_bill_no]

  193版本

  SELECT  [source_bill_type] AS [SourceBillType] , [source_bill_no] AS [SourceBillNo] , [source_bill_serial] AS [SourceBillSerial] , SUM(ISNULL([generated_qty],0)) AS [Qty]  FROM [barcode] [it] WITH(NOLOCK)   WHERE  ( ((( null = [it].[source_bill_type] ) AND ( null = [it].[source_bill_no] )) AND ( null = [it].[source_bill_serial] )) ) GROUP BY [source_bill_type],[source_bill_no],[source_bill_serial]

  生成的语句中 是null = [it].[source_bill_no] 

  0 回复
• hp9999 VIP0

  2025/9/25

  null值 ，能否生成 is null

  0 回复
• fate sta VIP0

  2025/9/25

  这个我看一下。

  0 回复
• fate sta VIP0

  2025/9/25

  更新最新版本已修复

  0 回复
• fate sta VIP0

  2025/9/25

  反过来就是字段 is null 。 你现在的是null = 字段

  0 回复
• hp9999 VIP0

  2025/9/25

  测试了，已修复

  0 回复