You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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.
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
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.
The text was updated successfully, but these errors were encountered: