An error occurred during binary arithmetic operations between the time field and the data field.

[LingweiKuang]

Bug Description

An error occurred during binary arithmetic operations between the time field and the data field.

To Reproduce

Assume that we execute the following statement under a database named testdb.

DROP TABLE t1;

CREATE TABLE t1( time TIMESTAMP, c0 INT);
INSERT INTO t1(time, c0) VALUES (1641024000000, 1);

# query 1 success
SELECT time, c0 FROM t1 WHERE (time - c0) > 0;
SELECT time, c0 FROM t1 WHERE (time + c0) > 0;
SELECT time, c0 FROM t1 WHERE (-(-c0)) > 0;

# query 2 error
SELECT time, c0 FROM t1 WHERE (time - (-c0)) > 0;

Expected Behavior

The query statement 1 and query statement 2 can both retrieve all the data.

Actual behaviour

Query 1 can retrieve all the data, but Query 2 returns an error: DB error: Invalid operation.

Environment

• OS：Ubuntu Server 22.04 LTS 64bit
• TDengine Version：3.3.3.0

Additional Context

Hello, TDengine team. I'd like to confirm with you whether this is a bug? Because Query 1 and Query 2 are equivalent.