rename table is not compatible with MySQL

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

---session 1
create table test(a int);
begin;
insert into test values(1)
---session 2
rename table test to test_bak;
---session3
select * from test;--table not exist
select * from test_bak;--success

admin show ddl jobs;
job is still running.

tidb log
job is not finish.

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

---session3
select * from test; ---success
select * from test_bak;---table not exist

### 3. What did you see instead (Required)
---session3
select * from test;--table not exist
select * from test_bak;--success

### 4. What is your TiDB version? (Required)
v7.5.6, v8.5.2