[Bug]: the result of select count(*) from table{snapshot = ''} is not correct after creating snapshot.

[Ariznawlll]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

main

Commit ID

2558e02

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

Expected Behavior

select count(*) from tran01{snapshot = 'sp09'}
3

Steps to Reproduce

drop database if exists test06;
create database test06;
use test06;
drop table if exists tran01;
create table tran01(col1 enum('red','blue','green'));
insert into tran01 values('red'),('blue'),('green');
create snapshot sp09 for account sys;
show snapshots;
select count(*) from tran01{snapshot = 'sp09'};     -->出错位置

Additional information

No response

[YANGGMM]

mysql> drop database if exists test06;
Query OK, 1 row affected (0.03 sec)

mysql> create database test06;
Query OK, 1 row affected (0.01 sec)

mysql> use test06;
Database changed
mysql> drop table if exists tran01;
Query OK, 0 rows affected (0.01 sec)

mysql> create table tran01(col1 enum('red','blue','green'));
Query OK, 0 rows affected (0.02 sec)

mysql> insert into tran01 values('red'),('blue'),('green');
Query OK, 3 rows affected (0.01 sec)

mysql> create snapshot sp09 for account sys;
Query OK, 0 rows affected (0.01 sec)

mysql> show snapshots;
+---------------+----------------------------+----------------+--------------+---------------+------------+
| SNAPSHOT_NAME | TIMESTAMP                  | SNAPSHOT_LEVEL | ACCOUNT_NAME | DATABASE_NAME | TABLE_NAME |
+---------------+----------------------------+----------------+--------------+---------------+------------+
| sp09          | 2024-05-08 09:01:25.125511 | account        | sys          |               |            |
+---------------+----------------------------+----------------+--------------+---------------+------------+
2 rows in set (0.00 sec)

mysql> select count(*) from tran01{snapshot = 'sp09'};
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.02 sec)

mysql> select count(*) from tran01{snapshot = 'sp09'};
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from tran01;
+----------+
| count(*) |
+----------+
|        3 |
+----------+
1 row in set (0.01 sec)

mysql> select count(*) from tran01{snapshot = 'sp09'};
+----------+
| count(*) |
+----------+
|        3 |
+----------+
1 row in set (0.00 sec)

[triump2020]

the cause had been found, pls wait for PR.

[Ariznawlll]

commit: 4d44f72

verified.

[matrix-meow]

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

[Ariznawlll]

removing tag, in progress