You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/02/25 07:27:08 UTC
[GitHub] [shardingsphere] Joker1995 edited a comment on issue #7523: Error in 'update' operation using shardingshpere
Joker1995 edited a comment on issue #7523:
URL: https://github.com/apache/shardingsphere/issues/7523#issuecomment-785680576
There is my situation:
the sharding configuration as follow:
the error message as follow:
### Error updating database. Cause: org.apache.shardingsphere.underlying.common.exception.ShardingSphereException: Can not update sharding key, logic table: [ad_user], column: [org.apache.shardingsphere.sql.parser.sql.segment.dml.assignment.AssignmentSegment@6c68540a].
### The error may exist in com/xxxx/xxxx/mapper/UserMapper.java (best guess)
### The error may involve com.xxxx.xxx.mapper.UserMapper.updateById-Inline
### The error occurred while setting parameters
### SQL: UPDATE ad_user SET code=?, province_id=?, province_name=?, city_id=?, city_name=?, terminal=?, project_name=?, site_id=?, tenant_id=?, create_ts=?, update_ts=? WHERE id=?
### Cause: org.apache.shardingsphere.underlying.common.exception.ShardingSphereException: Can not update sharding key, logic table: [ad_user], column: [org.apache.shardingsphere.sql.parser.sql.segment.dml.assignment.AssignmentSegment@6c68540a].
i don't modify multipart tables,why this problem occur?
----------------------------------------------------------------
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