Inconsistent Boolean Field Values

[tejasharwin]

Problem statement

I have two queries where the only difference between the queries is Query 2 has a narrower time range than Query 1. Note that Query 2's timerange is still captured by Query 1.

Given the above info, both my queries are showing different values for my Boolean field called 'omit' which is super strange. I expect Query 1's result to be exactly equal to Query 2's result for Query 2's timestamps.

Steps to reproduce:

1. Query a table with a Boolean field with a wide timerange from t1 to t2.
2. Make the same query but this time with a narrower time range but still within t1 and t2.
3. Compare the results of the Boolean field.

here is my Query 1 along with it's result:

SELECT var1, omit
FROM "bucket".."table"
WHERE time >= '2024-03-18T16:00:00Z' and time <= '2024-04-01T13:52:00Z' and id = 'abcdef'

Query 1 Result:
the omit field takes values false for 04/01/2024 13:49:00 and 04/01/2024 13:51:00

here is my Query 2 along with it's result:

SELECT var1, omit
FROM "bucket".."table"
WHERE time >= '2024-04-01T113:42:00Z' and time <= '2024-04-01T13:52:00Z' and id = 'abcdef'

Query 2 Result:
the omit field takes values true for 04/01/2024 13:49:00 and 04/01/2024 13:51:00

Expected behaviour:
I expected to see the same values for the Boolean field.

Actual behaviour:
I saw the omit field to be False in Query 1 and true in Query 2 for timestamps: 04/01/2024 13:49:00 and 04/01/2024 13:51:00. Therefore, these query results are inconsistent.

Environment info:

• InfluxDB 2.7

[tejasharwin]

cc: @sanderson