when do flashback table. The mysql.gc_delete_range table is not emptied.After gc the data will gone.

[erwadba]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

# tiup  playground v6.2.0  --host 0.0.0.0
# mysql -uroot -P4000 -h xx.xx.xx.xx
mysql> create database a;
mysql> use a;
mysql> create table t(id int);
mysql> insert into t values(1),(2),(3);
mysql> drop table t;
mysql> flashback table t;
mysql> select * from mysql.gc_delete_range;

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

mysql.delete range is empty. The data of flashback table will not be lost.

3. What did you see instead (Required)

mysql.delete range is not empty. The data is gone after gc .

4. What is your TiDB version? (Required)

mysql> select  tidb_version()\G
*************************** 1. row ***************************
tidb_version(): Release Version: v6.2.0
Edition: Community
Git Commit Hash: daf2b17cdfe30c02ce282361009fb5bdb05f2b0e
Git Branch: heads/refs/tags/v6.2.0
UTC Build Time: 2022-08-22 13:47:05
GoVersion: go1.18.5
Race Enabled: false
TiKV Min Version: 6.2.0-alpha
Check Table Before Drop: false
Store: tikv
1 row in set (0.00 sec)

mysql>