Skip to content

Inconsistent data after multi-schema change #61255

Closed

Description

@tangenta

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table t (id int, b int, c int, primary key(id) clustered);
insert into t values (1,1,1);

-- during backfill
delete from t where id = 1;
insert into t values (2,1,1);
delete from t where id = 2;

-- before merge
insert into t values (3, 1, 1);

alter table t add unique index b(b), add index c(c);
admin check table t;

2. What did you expect to see? (Required)

ADMIN CHECK success.

3. What did you see instead (Required)

ADMIN CHECK fail.

4. What is your TiDB version? (Required)

2dce924

Activity

  1. added
    type/bugThe issue is confirmed as a bug.
    affects-7.1This bug affects the 7.1.x(LTS) versions.
    affects-7.5This bug affects the 7.5.x(LTS) versions.
    affects-8.1This bug affects the 8.1.x(LTS) versions.
    affects-8.5This bug affects the 8.5.x(LTS) versions.
    on May 22, 2025
  2. self-assigned this
    on May 22, 2025
  3. added a commit that references this issue on May 23, 2025
    3912818
  4. added a commit that references this issue on May 24, 2025
    41eed15
  5. added a commit that references this issue on Jun 16, 2025
    3c2a22c
  6. added a commit that references this issue on Jun 17, 2025
    868592f
  7. added a commit that references this issue on Jul 10, 2025
    abc56fb
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

affects-7.1This bug affects the 7.1.x(LTS) versions.affects-7.5This bug affects the 7.5.x(LTS) versions.affects-8.1This bug affects the 8.1.x(LTS) versions.affects-8.5This bug affects the 8.5.x(LTS) versions.component/ddlThis issue is related to DDL of TiDB.impact/inconsistencyincorrect/inconsistency/inconsistentseverity/criticaltype/bugThe issue is confirmed as a bug.

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions