sabz90 commented on issue #7703: URL: https://github.com/apache/shardingsphere/issues/7703#issuecomment-712358482
> The query does not change the Sharding key of the table. If that value does not appear in SET statement > > > update ACCOUNT_INFO set name=??, account_id=??, zip=??, version=?? where id = ?? and version = ?? > > Sorry? `account_id` is a sharding key and in set clause, isn't it? Yes, but the value is same as what was already present in the DB. But yes, there's no way for sharding sphere to know if the new value is equal to the old value, without it being specified in the where clause. Unfortunately, hibernate doesn't provide a way to include custom columns in the where clause ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected]
