联表更新生成的sql有错误 返回

SqlSugar 沟通中
1 197

版本: 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