matrixorigin / matrixorigin/matrixone
[Bug]: No statement is returned when query from statement_info at t1 and get 34 rows when query at t2
- Dominant language
- Go
- Stars
- 1.9k
- Forks
- 311
- Avg merge
- 1d 3h
- Merged PRs (30d)
- 768
Description
### Is there an existing issue for the same bug?
- [X] I have checked the existing issues.
### Branch Name
v1.0.2
### Commit ID
8081e0516
### Other Environment Information
```Markdown
- Hardware parameters:
- OS type:
- Others:
```
### Actual Behavior
Run the following query at `2024/01/19 07:25:05.305830 +0000` and get 0 result:
```
2024/01/19 07:25:05.305830 +0000 DEBUG worker/controller.go:378 trace {"elapsed": "33.518872ms", "rows": 0, "sql": "SELECT `statement_id`,any_value(`stats`) as `stats`,any_value(`duration`) as `duration`,any_value(`sql_source_type`) as `sql_source_type`,any_value(`account`) as `account`,any_value(`response_at`) as `response_at` FROM `system`.`statement_info` WHERE status != 'Running' and account != 'sys' and account != 'mocloud_mo_ob' and response_at >= '2024-01-19 07:19:00' and response_at < '2024-01-19 07:20:00' GROUP BY `statement_id`"}
```
Run the same query now and get 34 rows.
### Expected Behavior
Get the same query result for the query at any time
### Steps to Reproduce
```Markdown
NA
```
### Additional information
_No response_
Contributor guide
Assessment
This issue has not been assessed yet.