heqiao commented on issue #7703: URL: https://github.com/apache/shardingsphere/issues/7703#issuecomment-716296721
Thanks for the detailed response with a solution. @tristaZero That's exactly what was happening. When `updatable = false` is being used, the `where clause` does not contain `shardingKey=xx` and will end up with all shards updating. Additionally, the `where clause` only contains `pk =yy` no matter `updatable = false` is being used or not. The logic in the third paragraph makes a lot sense to me. Just want to make sure the sharding key will be included in `where clause` in the PASS cases. ---------------------------------------------------------------- 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]
