Same query, different results

__Steps to reproduce:__
List the minimal actions needed to reproduce the behavior.
```
> select * from ctr where "some"='tag-6000' and time=1678798961952865493 limit 1;
> select * from ctr where "some"='tag-6000' and time=1678798961952865493 limit 1;
name: ctr
time n some
---- - ----
1678798961952865493 0 tag-6000
```

__Expected behavior:__
Describe what you expected to happen.

__Actual behavior:__
Describe What actually happened.

__Environment info:__
```
#influxd version
InfluxDB v1.8.10 (git: 1.8 688e697c51fd)
```

* System info: Run `uname -srm` and copy the output here
* InfluxDB version: Run `influxd version` and copy the output here
* Other relevant environment details: Container runtime, disk info, etc

__Config:__
Copy any non-default config values here or attach the full config as a gist or file.

__Logs:__
Include snippet of errors in log.

__Performance:__
Generate profiles with the following commands for bugs related to performance, locking, out of memory (OOM), etc.

```sh
# Commands should be run when the bug is actively happening.
# Note: This command will run for ~30 seconds.
curl -o profiles.tar.gz "http://localhost:8086/debug/pprof/all?cpu=30s"
iostat -xd 1 30 > iostat.txt
# Attach the `profiles.tar.gz` and `iostat.txt` output files.
```

Start by reproducing the two SELECT statements shown against InfluxDB v1.8.10 and compare their results. The issue does not name source files or tests; done would mean identifying why identical queries differ and demonstrating consistent results with a regression test or reproduction.

Written by the indexing model from the issue text.