跨方法事务方案(IsShardSameThread= true)sql语句错乱 返回

求助
492

update(

SELECT

*

FROM

product_plan

WHERE

(

(PlanSchedule >= '2019-12-30')

AND (SpecificationId = 5)

)

ORDER BY

PlanSchedule ASC

) t

SET `TenantId` = 1,

 `ProductCode` = 'SP0010002',

 `SpecificationId` = 2,

 `PlanSchedule` = '2020-01-01 00:00:00',

 `PlanNumber` = 100,

 `GroupNumber` = 20,

 `GroupNo` = '',

 `OccupyNumber` = 0,

 `SoldNumber` = 0,

 `OccupySoldNumber` = 0,

 `ResidueNumber` = 0,

 `DirectAdultPrice` = 5000,

 `DirectChildPrice` = 0,

 `DirectSingleRoomDifferen` = 0,

 `DirectBabyPrice` = 0,

 `IsStopSale` = 0,

 `Remark` = '',

 `CreateTime` = '2019-12-30 10:42:14',

 `CreateUserName` = 'xxx',

 `CreateUserId` = 597,

 `UpdateTime` = '2019-12-30 10:42:14',

 `UpdateUserName` = 'xxx',

 `UpdateUserId` = 597

WHERE

`Id` = 3


热忱回答0

版块

学习文档

最新会员

发布达人

回贴达人