There is a logical error in filtering when the Time field is enclosed in parentheses

[LingweiKuang]

Dear InfluxDB Team, When we enclose the time field in parentheses within a predicate expression, in the following query, the actual query range for time should be greater than the timestamp 1741024000000000000. However, data with a timestamp of 1641024000000000000 is still being retrieved, indicating a logical error.

Steps to reproduce

In the latest version of InfluxDB, if we have an organization named "organization", we can use the Influx client to execute the following commands to create a bucket and write the specified data into that bucket.

influx bucket delete --name db0
influx bucket create --name db0 --org organization

influx write \
  -b db0 \
  -o organization \
  -p ns \
  't0,t0_tag0=initTag t0_f0=1 1641024000000000000'

Next, we use the influx v1 shell command to enter the Influx shell backend and execute the following query statement:

# query 1
SELECT t0_f0 FROM db0.autogen.t0 WHERE (time) >= (1741024000000000000)

Expected behaviour

Query 1 returned result set: empty set

Actual behaviour

Query 1 returned result set: 1

Environment info

Influx CLI dev (git: a79a2a1b825867421d320428538f76a4c90aa34c) build_date: 2024-04-16T14:34:32Z

InfluxDB OSS v2.7.11 (git: fbf5d4a)

Linux 5.15.0-94-generic x86_64

[davidby-influx]

Does the query work if you remove the parentheses?

[LingweiKuang]

Thank you for your reply, it will execute successfully.