[GitHub] [shardingsphere] wanghaichao2195 commented on issue #5596: Can not update sharding key,

[GitBox <gi...@apache.org>]

wanghaichao2195 commented on issue #5596:
URL: https://github.com/apache/shardingsphere/issues/5596#issuecomment-702520164


   I have this issue today, but I'm 100 percent sure the sharding key is the same (in my case is "uid"), but in ShardingUpdateStatementValidator, 
   the "shardingColumnSetAssignmentValue" is the correct value of uid,
   but in 
   ```java
   if (whereSegmentOptional.isPresent()) {
        shardingValue = getShardingValue(whereSegmentOptional.get(), parameters, shardingColumn);
   } 
   ```
   the getShardingValue will return empty because the identifier in it is "id" (which is the primary key, not shardingColumn in my table)
   ![Screen Shot 2020-10-01 at 9 32 09 PM](https://user-images.githubusercontent.com/24919562/94888326-92ed5980-042d-11eb-8a1d-55dd3e1dcf78.png)
   
   


----------------------------------------------------------------
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:
users@infra.apache.org