The binary comparison operator causes a syntax parsing exception for the operator.

[LingweiKuang]

Dear InfluxDB Team, I have a bug that I need to report to you.

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 \
  --bucket db0 \
  --precision s "
t0,t0_tag0=initTag t0_f0=0u 1641024000
t0,t0_tag0=initTag t0_f0=1u 1641024001
t0,t0_tag1=initTag t0_f0=0u 1641024000"

Next, we use the Influx v1 shell command to enter the Influx shell backend and execute two types of query statements:

# query 1 success
SELECT t0_f0::integer, t0_tag0 FROM db0.autogen.t0 WHERE (TRUE != ((t0_f0::integer) OR (t0_tag0)))
SELECT t0_f0::integer, t0_tag0 FROM db0.autogen.t0 WHERE (((t0_f0::integer) OR (t0_tag0)) != TRUE)

# query 2 error 
SELECT t0_f0::integer, t0_tag0 FROM db0.autogen.t0 WHERE ((t0_f0::integer) OR (t0_tag0))

Expected behaviour

Both Query 1 and Query 2 should report the error: "Error: invalid condition expression: t0_f0::integer."

Actual behaviour

Query 1 is able to retrieve all the data, while Query 2 reports the error: "Error: invalid condition expression: t0_f0::integer."

Could this be a syntax error? It appears that the binary comparison operator might be causing a syntax evaluation exception in the clause ((t0_f0::integer) OR (t0_tag0)). Could you please confirm?

Environment info

Influx CLI dev (git: none) build_date: 2023-04-28T14:24:14Z

InfluxDB OSS v2.7.10 (git: f302d97)

Linux 5.15.0-94-generic x86_64