PolarDB:Why is an error reported when an UPDATE statement is executed on a table shard key in PolarDB-X 1.0? Can the values of shard key fields be changed in PolarDB-X 1.0?

Yes, the values of shard key fields can be changed in PolarDB-X 1.0. In V5.4.7-16000638 or later, UPDATE statements can be executed to update shard key fields of logical tables. Therefore, if an error is reported when an UPDATE statement is executed on a table shard key, we recommend that you first check whether the version of PolarDB-X 1.0 instance is V5.4.7-16000638 or later. If the version is not V5.4.7-16000638 or later, we recommend that you update Upgrade the version to V5.4.7-16000638 or later and then attempt to execute an UPDATE statement on the shard key.