子查询为空时通过??0自动赋值为0会导致主表别名消失返回

SqlSugar 沟通中

 4  473

悬赏：0 飞吻

1.含??0，生成的sql主表会缺少别名`o`

o.ShouldExpendAmount==

(SqlFunc.Subqueryable<FinanceThirdPartyOrderApplyPayEntity>()

.Where(x => x.ThirdPartyOrderId == o.Id)

.Where(x => x.IsApproved == true)

.Sum(x => x.Amount)??0)

2.不含??0，生成的sql主表会正常生成别名`o`，但子查询实际数据为null，无法正常比较数字是否相等

o.ShouldExpendAmount==

SqlFunc.Subqueryable<FinanceThirdPartyOrderApplyPayEntity>()

.Where(x => x.ThirdPartyOrderId == o.Id)

.Where(x => x.IsApproved == true)

.Sum(x => x.Amount)

已升级最新版本SqlSugarCore包

热忱回答（4）