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

TiCDC did not correctly use the primary key as the where clause for the Delete statement. #9812

Closed
asddongmen opened this issue Sep 26, 2023 · 0 comments · Fixed by #9813
Closed
Assignees
Labels
affects-6.1 This bug affects the 6.1.x(LTS) versions. affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. area/ticdc Issues or PRs related to TiCDC. severity/moderate type/bug The issue is confirmed as a bug.

Comments

@asddongmen
Copy link
Contributor

What did you do?

I use TiCDC to synchronize a table with one primary key (consisting of two columns of int values) and a non-null unique index (consisting of 3 columns). I observed from the logs that the where statement of the Delete statement generated by TiCDC did not correctly use the primary key as an execution condition.

What did you expect to see?

TiCDC uses primary key to generate the where clause of delete statements.

What did you see instead?

as above.

Versions of the cluster

Upstream TiDB cluster version (execute SELECT tidb_version(); in a MySQL client):

(paste TiDB cluster version here)

Upstream TiKV version (execute tikv-server --version):

(paste TiKV version here)

TiCDC version (execute cdc version):

(paste TiCDC version here)
@asddongmen asddongmen added type/bug The issue is confirmed as a bug. area/ticdc Issues or PRs related to TiCDC. affects-6.1 This bug affects the 6.1.x(LTS) versions. affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. labels Sep 26, 2023
@asddongmen asddongmen self-assigned this Sep 26, 2023
@ti-chi-bot ti-chi-bot bot closed this as completed in #9813 Nov 1, 2023
@asddongmen asddongmen added the affects-7.5 This bug affects the 7.5.x(LTS) versions. label Jul 25, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-6.1 This bug affects the 6.1.x(LTS) versions. affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. area/ticdc Issues or PRs related to TiCDC. severity/moderate type/bug The issue is confirmed as a bug.
Projects
Development

Successfully merging a pull request may close this issue.

1 participant