Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

tidb_row_checksum() calculate the returned value on the real time instead of previous stored value #52590

Closed
3AceShowHand opened this issue Apr 12, 2024 · 0 comments · Fixed by #52511
Assignees
Labels
type/enhancement The issue or PR belongs to an enhancement.

Comments

@3AceShowHand
Copy link
Contributor

Enhancement

At the moment, when use tidb_row_checksum() function return the checksum value which was calculated when the data inserted, this value may be stable since the table schema change.

create table t (a int primary key, b int);
insert into t values (1, 2);                         # assume the checksum is `123`

alter table t add column c int default 1; 

select tidb_row_checksum() from t where a = 1;  ## `123` is returned, but the real checksum may be `234`
@3AceShowHand 3AceShowHand added the type/enhancement The issue or PR belongs to an enhancement. label Apr 12, 2024
@3AceShowHand 3AceShowHand self-assigned this Apr 12, 2024
ti-chi-bot bot pushed a commit that referenced this issue May 11, 2024
… incorrect checksum caused by schema change (#52511)

close #52590
terry1purcell pushed a commit to terry1purcell/tidb that referenced this issue May 17, 2024
RidRisR pushed a commit to RidRisR/tidb that referenced this issue May 23, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
1 participant