[Bug]: Temp Table: Run auto_increment case in pessimistic mode multi times gets different result.

[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):1e2b2428e5743464f50abda83d5a06fdf54e36ae
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

Run auto_increment case multi times occurs different result, as follows:

Expected Behavior

Steps to Reproduce

Drop table if exists auto_increment04;
Create temporary table auto_increment04(col1 int primary key auto_increment) auto_increment = 10;
insert into auto_increment04 values();
Select * from auto_increment04;
Insert into auto_increment04 values();
select last_insert_id();
Insert into auto_increment04 values(100);
Insert into auto_increment04 values(200);
Insert into auto_increment04 values(10);
Insert into auto_increment04 values(11);
Select * from auto_increment04;
Drop table auto_increment04;

Additional information

No response

[ouyuanning]

not working on it

[ouyuanning]

当前临时表的实现需要重构，以满足悲观事务的需求。
建议统一放在一个临时表重构的issue下。

[Ariznawlll]

wating for temporary table refactor.

[matrix-meow]

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

[fengttt]

This issue is also temp table related. Changed title. Keep all temp table issues in backlog.