联表更新生成的sql有错误 返回
测试小白 发布于2周前
版本: SqlSugar 5.1.4.207
数据库: sqlsugar
语句:
var tmpCloseTable = "#DWR_Import_TmpCloseTable";
int totalClosed = await _db.Updateable<DWFTask>().InnerJoin<DWR_Import_TmpCloseTable>((a, b) => a.iD == b.taskId, tmpCloseTable)
.SetColumns((a, b) => new DWFTask() { updateTime = currentTime, taskState = 2 })
.Where((a, b) => a.taskState == 1).ExecuteCommandAsync();
打印Sql:
UPDATE [a] SET
[a].[TaskState]= 2 ,[a].[UpdateTime]= CAST('2026-07-16 14:27:39.392' AS DATETIME) FROM [#DWR_Import_TmpCloseTable] [a]
JOIN [DWR_Import_TmpCloseTable] [b] ON ( [a].[ID] = [b].[taskId] )
WHERE ( [a].[TaskState] = 1 )
应该生成的Sql:
UPDATE [a] SET
[a].[TaskState]= 2 ,[a].[UpdateTime]= CAST('2026-07-16 14:27:39.392' AS DATETIME) FROM [DWFTask] [a]
JOIN [#DWR_Import_TmpCloseTable] [b] ON ( [a].[ID] = [b].[taskId] )
WHERE ( [a].[TaskState] = 1 )
热忱回答(1)
-
fate sta VIP0
2周前我这边看一下。
0 回复