Skipped event

[Abigael-JT]

Describe the bug

The last two queries skips one event:

test 1#: index=xyx sourcetype=abc earliest=2024-11-01T00:00:00+04:00 latest=2024-11-02T00:00:00+02:00 | stats earliest(_time), latest(_time)

timestamp of first event in results: 2024-11-01T01:37:57.386+02:00

test 2#: index=xyx sourcetype=abc earliest=2024-11-01T00:00:00+02:00 latest=2024-11-02T00:00:00+02:00 | stats earliest(_time), latest(_time)

timestamp of first event in results: 2024-11-01T02:12:56.051+02:00

test 3#(no timezones at all): index=xyx sourcetype=abc earliest=2024-11-01T00:00:00 latest=2024-11-02T00:00:00 | stats earliest(_time), latest(_time)

timestamp of first event in results: 2024-11-01T02:12:56.051+02:00

Expected behavior

All the three queries should have the event with timestamp 2024-11-01T01:37:57.386+02:00, but only the first query returns the event
How to reproduce

Screenshots

Software version

pth_10 version: 8.2.1
pth_03 version: 9.2.0

Desktop (please complete the following information if relevant):

• OS:
• Browser:
• Version:

Additional context

[Abigael-JT]

fix issue #439 to make it easier to troubleshoot