Inconsistent database state with MySQL 8.0 for updating after insert

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

```sql
CREATE TABLE t0 (c0 INT);
INSERT INTO t0 VALUES (1),(2);

/* T1 */ BEGIN;
/* T2 */ BEGIN;
/* T1 */ SELECT t0.c0 FROM t0;
/* T2 */ INSERT INTO t0 VALUES (3);
/* T2 */ COMMIT;
/* T1 */ UPDATE t0 SET c0 = 0;
/* T1 */ COMMIT;
/* T3 */ SELECT t0.c0 FROM t0;
```
### 2. What did you expect to see? (Required)
In MySQL.
```sql
/* T1 */ BEGIN;
/* T2 */ BEGIN;
/* T1 */ SELECT t0.c0 FROM t0;
+------+
| c0 |
+------+
| 1 |
| 2 |
+------+
2 rows in set (0.00 sec)
/* T2 */ INSERT INTO t0 VALUES (3);
Query OK, 1 row affected (0.00 sec)
/* T2 */ COMMIT;
/* T1 */ UPDATE t0 SET c0 = 0;
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3 Changed: 3 Warnings: 0
/* T1 */ COMMIT;
/* T3 */ SELECT t0.c0 FROM t0;
+------+
| c0 |
+------+
| 0 |
| 0 |
| 0 |
+------+
3 rows in set (0.00 sec)
```
### 3. What did you see instead (Required)
```sql
/* T1 */ BEGIN;
/* T2 */ BEGIN;
/* T1 */ SELECT t0.c0 FROM t0;
+------+
| c0 |
+------+
| 1 |
| 2 |
+------+
2 rows in set (0.00 sec)
/* T2 */ INSERT INTO t0 VALUES (3);
Query OK, 1 row affected (0.00 sec)
/* T2 */ COMMIT;
/* T1 */ UPDATE t0 SET c0 = 0;
Query OK, 2 rows affected (0.01 sec)
Rows matched: 2 Changed: 2 Warnings: 0
/* T1 */ COMMIT;
/* T3 */ SELECT t0.c0 FROM t0;
+------+
| c0 |
+------+
| 0 |
| 0 |
| 3 |
+------+
3 rows in set (0.00 sec)
````
### 4. What is your TiDB version? (Required)

Release Version: v8.2.0
Edition: Community
Git Commit Hash: 821e491a20fbab36604b36b647b5bae26a2c1418
Git Branch: HEAD
UTC Build Time: 2024-07-05 09:16:25
GoVersion: go1.21.10
Race Enabled: false
Check Table Before Drop: false
Store: tikv