数据库以时间范围查询，结果返回异常

【DM版本】: 8
【操作系统】： 内核版本 4.19.90-24.4.v2101.ky10.aarch64
【CPU】: ARMv8 CPU
【问题描述】*：使用时间范围查询，时间范围扩大，返回结果变少。

第一次查询

SELECT event_code, starts_at FROM "ferry"."alert_event"  WHERE (starts_at >= '2024-04-15 00:00:00 +08:00') AND (starts_at < '2024-04-15 23:00:00 +08:00');

返回结果：

行号     event_code                           starts_at
---------- ------------------------------------ ---------------------------------
1          6fbe1026-5eff-4aa3-8022-dc630da6d78c 2024-04-15 13:59:09.866000 +08:00
2          243e02cf-3db1-4783-aa0f-3dd6e0dac202 2024-04-15 13:59:09.866000 +08:00
3          243e02cf-3db1-4783-aa0f-3dd6e0dac202 2024-04-15 15:58:09.866000 +08:00
4          243e02cf-3db1-4783-aa0f-3dd6e0dac202 2024-04-15 15:58:09.866000 +08:00
5          62b930da-fd3d-4429-9f46-8dd1034b07e8 2024-04-15 15:58:09.866000 +08:00
6          b8c8f51f-a7c0-46f3-bf5d-6df18d423bae 2024-04-15 15:58:09.866000 +08:00
7          f72b94ac-73d4-4193-8b2b-a45297d571bb 2024-04-15 17:20:09.866000 +08:00
8          8fc1b2cb-2f23-4d95-8366-3423e8c46e16 2024-04-15 17:20:09.866000 +08:00
9          5a248495-d4d5-44eb-bf6b-f90661c414f7 2024-04-15 18:09:09.866000 +08:00
10         a491cc12-6897-4d46-8bb8-96fe6bb04655 2024-04-15 18:09:09.866000 +08:00
11         777ffa4a-ad04-4829-8318-a88d095f0ec4 2024-04-15 18:41:39.866000 +08:00

行号     event_code                           starts_at
---------- ------------------------------------ ---------------------------------
12         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 18:41:39.866000 +08:00
13         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
14         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
15         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
16         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
17         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
18         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
19         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
20         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
21         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
22         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00

行号     event_code                           starts_at
---------- ------------------------------------ ---------------------------------
23         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
24         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
25         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
26         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
27         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
28         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
29         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
30         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
31         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
32         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
33         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00

行号     event_code                           starts_at
---------- ------------------------------------ ---------------------------------
34         4fe452d1-f88f-451e-b9f6-83f94bb53011 2024-04-15 19:05:54.866000 +08:00
35         8c795ad1-567a-4b7d-b3d2-ff3d196c8fa9 2024-04-15 19:05:54.866000 +08:00
36         5e87d9ce-78e7-4a88-bebd-ed8ca39d3929 2024-04-15 19:05:54.866000 +08:00

36 rows got

第二次查询

SELECT event_code, starts_at FROM "ferry"."alert_event"  WHERE (starts_at >= '2024-04-15 00:00:00 +08:00') AND (starts_at < '2024-04-16 00:00:00 +08:00');

返回结果:

未选定行

第三次查询

SELECT event_code, starts_at FROM "ferry"."alert_event"  WHERE (starts_at >= '2024-04-15 00:00:00 +08:00') AND (starts_at < '2024-04-16 04:00:00 +08:00');

返回结果:

行号     event_code                           starts_at
---------- ------------------------------------ ---------------------------------
1          6fbe1026-5eff-4aa3-8022-dc630da6d78c 2024-04-15 13:59:09.866000 +08:00
2          243e02cf-3db1-4783-aa0f-3dd6e0dac202 2024-04-15 13:59:09.866000 +08:00
3          243e02cf-3db1-4783-aa0f-3dd6e0dac202 2024-04-15 15:58:09.866000 +08:00
4          243e02cf-3db1-4783-aa0f-3dd6e0dac202 2024-04-15 15:58:09.866000 +08:00
5          62b930da-fd3d-4429-9f46-8dd1034b07e8 2024-04-15 15:58:09.866000 +08:00
6          b8c8f51f-a7c0-46f3-bf5d-6df18d423bae 2024-04-15 15:58:09.866000 +08:00

6 rows got