[Bug]: insert into table success rather than table does not exists in pessimistic mode.

[Ariznawlll]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

As follows：
https://github.com/matrixorigin/matrixone/actions/runs/5654167205/job/15316701838?pr=10859

Expected Behavior

No response

Steps to Reproduce

drop table if exists atomic_table_14;
create table atomic_table_14(c1 int,c2 varchar(25));
insert into atomic_table_14 values (3,"a"),(4,"b"),(5,"c");
start transaction ;
alter table atomic_table_14 add  index key1(c1);
-- @session:id=1{
use transaction_enhance;
-- @wait:0:commit
drop table atomic_table_14;
-- @session}
insert into atomic_table_14 values (6,"a"),(7,"b");
select * from atomic_table_14;
commit;
select * from atomic_table_14;

Additional information

No response

[zhangxu19830126]

fixed

[Ariznawlll]

Verified!

[matrix-meow]

Hello @Ariznawlll. The bug issue in the BVT test code has not been removed,issues automatically open.