SqlSugarCore 无法批量更新Doris 返回
紫陌红尘 发布于2025/11/28
SqlSugarCore 版本: 5.1.4.210
Doris 版本: 3.0.5
使用 db.Updateable(集合).ExecuteCommand0 报错信息: mismatched input 'INNER' expecting {'(', 'SET'}(line 1. pos 28)
热忱回答（2）
-
fate sta VIP0
2025/11/28AOP 拿到SQL ,看一下SQL为什么报错
0 回复 -
紫陌红尘 VIP0
2025/11/28
@fate sta：
UPDATE `ch_op_change` S INNER JOIN (
SELECT 2 AS `id`,@BillNo_1 AS `bill_no`,'2025-11-20 00:00:00.000' AS `bill_date`,2 AS `bill_type`,@Channel_2 AS `Channel`,'2025-12-01 00:00:00.000' AS `start_date`,'2025-12-31 00:00:00.000' AS `end_date`,NULL AS `Note`,0 AS `op_org_id`,0 AS `op_dept_id`,@OpId_3 AS `op_id`,@SourceBillNo_4 AS `source_bill_no`,NULL AS `business_type`,0 AS `document_status`,@CreatorId_5 AS `creator_id`,'2025-11-20 17:36:23.000' AS `create_time`,@ModifierId_6 AS `modifier_id`,'2025-11-28 11:44:33.062' AS `modify_time`,NULL AS `approver_id`,'2025-11-25 14:49:22.000' AS `approve_time`,NULL AS `closer_id`,0 AS `close_status`,NULL AS `close_time`,0 AS `cancel_status`,NULL AS `canceller_id`,NULL AS `cancel_time`,@VersionNo_7 AS `version_no`,NULL AS `change_id`,0 AS `change_status`,NULL AS `change_reason`,NULL AS `change_time`
) T ON S.`id`=T.`id`
SET S.`bill_no`=T.`bill_no`,S.`bill_date`=T.`bill_date`,S.`bill_type`=T.`bill_type`,S.`Channel`=T.`Channel`,S.`start_date`=T.`start_date`,S.`end_date`=T.`end_date`,S.`Note`=T.`Note`,S.`op_org_id`=T.`op_org_id`,S.`op_dept_id`=T.`op_dept_id`,S.`op_id`=T.`op_id`,S.`source_bill_no`=T.`source_bill_no`,S.`business_type`=T.`business_type`,S.`document_status`=T.`document_status`,S.`creator_id`=T.`creator_id`,S.`create_time`=T.`create_time`,S.`modifier_id`=T.`modifier_id`,S.`modify_time`=T.`modify_time`,S.`approver_id`=T.`approver_id`,S.`approve_time`=T.`approve_time`,S.`closer_id`=T.`closer_id`,S.`close_status`=T.`close_status`,S.`close_time`=T.`close_time`,S.`cancel_status`=T.`cancel_status`,S.`canceller_id`=T.`canceller_id`,S.`cancel_time`=T.`cancel_time`,S.`version_no`=T.`version_no`,S.`change_id`=T.`change_id`,S.`change_status`=T.`change_status`,S.`change_reason`=T.`change_reason`,S.`change_time`=T.`change_time` ;
0 回复