Set default DDL still work after rename table, which cause TiCDC fail

[maxshuang]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

1. Set up a TiDB cluster using Tiup

tiup  playground  v5.3.0 --tag 530.1   --db 1 --kv 3 --pd 1  --ticdc 1 

2. Create database schrddl for test
3. Using schrddl to test TiDB

go get github.com/PingCAP-QE/schrddl
GO111MODULE=on go build -o ./schrddl github.com/PingCAP-QE/schrddl
./schrddl --mode=parallel  --db="schrddl"  --time=30s  --concurrency=5 --output='schrddl.out'

4. Check the ddl history

curl  http://127.0.0.1:10080/ddl/history >> ddl.job

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

ddl jobs run normal

3. What did you see instead (Required)

A strange DDL sequence

"query": "CREATE TABLE `e71e58cd-5e43-4138-9ebd-83280727eac1` (`321c2ad3-3f26-4e8c-90fd-adedf2fd1349` DECIMAL(19,7), `e12cbd81-31a9-4f74-9b07-c460eebbd04c` CHAR(107), PRIMARY KEY (`321c2ad3-3f26-4e8c-90fd-adedf2fd1349`, `e12cbd81-31a9-4f74-9b07-c460eebbd04c`)) COMMENT 'd3ce9d00-f1a7-41d0-a8b4-aa59d0883b59' CHARACTER SET 'utf8' COLLATE 'utf8_bin'",
 "query": "ALTER TABLE `e71e58cd-5e43-4138-9ebd-83280727eac1` RENAME AS `28bcfea3-0175-486e-b2f4-dbbade6fa6cf`",
"query": "ALTER TABLE `e71e58cd-5e43-4138-9ebd-83280727eac1` ALTER `e12cbd81-31a9-4f74-9b07-c460eebbd04c` SET DEFAULT 'xu3kigyzkibqhhtcf2tt1pi5il6b81getrxk4ovr6a686m68jouu6d01nah2htf7kcn5xz3h8zl'",

Set default DDL still work after rename table， but it will cause error in TiCDC because after renaming the table, the original table doesn't exists any more.

related log: 归档.zip

4. What is your TiDB version? (Required)

mysql> select tidb_version();
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version() |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v5.3.0
Edition: Community
Git Commit Hash: 4a1b2e9
Git Branch: heads/refs/tags/v5.3.0
UTC Build Time: 2021-11-24 13:31:18
GoVersion: go1.16.4
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)