lMasterSparkl commented on issue #7703: URL: https://github.com/apache/shardingsphere/issues/7703#issuecomment-1068813952
> @lMasterSparkl `update post set update_dt=?, did=?, base_like=?, base_pv=?, base_share=?, discuss=?, game_id=?, hot=?, images=?, is_delete=?, is_official=?, is_top=?, level=?, official_head=?, official_nick_name=?, official_title=?, post_id=?, pv=?, reply1did=?, reply1id=?, reply2did=?, reply2id=?, reply_did=?, share=?, tag=?, text=?, topic_id=?, topic_name=?, up=?, videos=? where id=?` > > Judging from your sql, you are trying to update `dids` with id = ?, so this exception occurs. > > There are two ways to solve it, 1. Do not update the did field, 2. Update the did field, and add the did condition of the same routing result to the where segment. @strongduanmu **as I have say before in this comment I compared the did column and it's the same so why the excute sql do not skip did column, I think this is the Focus.** > > Hi @lMasterSparkl, has the value of the sharding column changed in your update statement? We have support update sharding column when the sharding routing result keep the same in pr #13906, you can try it. > > @strongduanmu > > no the sharding column is not changed .I guess it's not execute that skip logic , here's my debug pic. > >  -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
