[Bug] Problems with read, reading data that has already been modified.

[liikeuforever]

Describe the bug

This is an update to a previous issue with Compact reading old data, when performing reads and writes of data, Compact vnode 3 does not perform a Compact operation（no level scores to compact）, but instead performs a flush memory drop. So the problem is localized to the Reader.

To Reproduce

public ❯ CREATE TABLE air (visibility DOUBLE,temperature DOUBLE,presssure DOUBLE,TAGS(station));
INSERT INTO air (TIME, station, visibility, temperature, presssure) VALUES (1667456411000, 'XiaoMaiDao2', 56, 69, 411);
INSERT INTO air (TIME, station, visibility, temperature, presssure) VALUES (1667456421000, 'XiaoMaiDao2', 56, 69, 412);
INSERT INTO air (TIME, station, visibility, temperature, presssure) VALUES (1667456411000, 'XiaoMaiDao3', 56, 69, 411);
INSERT INTO air (TIME, station, visibility, temperature, presssure) VALUES (1667456421000, 'XiaoMaiDao3', 56, 69, 412);
INSERT INTO air (TIME, station, visibility, temperature, presssure) VALUES (1667456411000, 'XiaoMaiDao4', 56, 69, 411);
INSERT INTO air (TIME, station, visibility, temperature, presssure) VALUES (1667456421000, 'XiaoMaiDao4', 56, 69, 412);
INSERT INTO air (TIME, station, visibility, temperature, presssure) VALUES (1667456411000, 'XiaoMaiDao5', 56, 69, 411);
INSERT INTO air (TIME, station, visibility, temperature, presssure) VALUES (1667456421000, 'XiaoMaiDao5', 56, 69, 412);

INSERT INTO air (TIME, station, visibility, temperature, presssure) VALUES (1667456411000, 'XiaoMaiDao1', 56, 69, 411);
INSERT INTO air (TIME, station, visibility, temperature, presssure) VALUES (1667456411000, 'XiaoMaiDao1', 56, 69, 412);
Query took 0.055 seconds.

public ❯ select * from air;
+----------------------------+-------------+------------+-------------+-----------+
| time                       | station     | visibility | temperature | presssure |
+----------------------------+-------------+------------+-------------+-----------+
| 1970-01-01T00:27:47.456411 | XiaoMaiDao1 | 56.0       | 69.0        | 412.0     |
| 1970-01-01T00:27:47.456411 | XiaoMaiDao4 | 56.0       | 69.0        | 411.0     |
| 1970-01-01T00:27:47.456421 | XiaoMaiDao4 | 56.0       | 69.0        | 412.0     |
| 1970-01-01T00:27:47.456411 | XiaoMaiDao2 | 56.0       | 69.0        | 411.0     |
| 1970-01-01T00:27:47.456421 | XiaoMaiDao2 | 56.0       | 69.0        | 412.0     |
| 1970-01-01T00:27:47.456411 | XiaoMaiDao3 | 56.0       | 69.0        | 411.0     |
| 1970-01-01T00:27:47.456421 | XiaoMaiDao3 | 56.0       | 69.0        | 412.0     |
| 1970-01-01T00:27:47.456411 | XiaoMaiDao5 | 56.0       | 69.0        | 411.0     |
| 1970-01-01T00:27:47.456421 | XiaoMaiDao5 | 56.0       | 69.0        | 412.0     |
+----------------------------+-------------+------------+-------------+-----------+
Query took 0.014 seconds.

public ❯ compact vnode 3;
Query took 0.026 seconds.
public ❯ select * from air;
+----------------------------+-------------+------------+-------------+-----------+
| time                       | station     | visibility | temperature | presssure |
+----------------------------+-------------+------------+-------------+-----------+
| 1970-01-01T00:27:47.456411 | XiaoMaiDao3 | 56.0       | 69.0        | 411.0     |
| 1970-01-01T00:27:47.456421 | XiaoMaiDao3 | 56.0       | 69.0        | 412.0     |
| 1970-01-01T00:27:47.456411 | XiaoMaiDao2 | 56.0       | 69.0        | 411.0     |
| 1970-01-01T00:27:47.456421 | XiaoMaiDao2 | 56.0       | 69.0        | 412.0     |
| 1970-01-01T00:27:47.456411 | XiaoMaiDao1 | 56.0       | 69.0        | 411.0     |
| 1970-01-01T00:27:47.456411 | XiaoMaiDao5 | 56.0       | 69.0        | 411.0     |
| 1970-01-01T00:27:47.456421 | XiaoMaiDao5 | 56.0       | 69.0        | 412.0     |
| 1970-01-01T00:27:47.456411 | XiaoMaiDao4 | 56.0       | 69.0        | 411.0     |
| 1970-01-01T00:27:47.456421 | XiaoMaiDao4 | 56.0       | 69.0        | 412.0     |
+----------------------------+-------------+------------+-------------+-----------+
Query took 0.024 seconds.

Expected behavior

No response

Additional context

No response