The combination of the IN operator and the BETWEEN operator contains a logical error.

Bug Description

The abstract expression sequence is: time IN (constant) AND time BETWEEEN (constant) AND (constant)

To Reproduce

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

DROP TABLE IF EXISTS t1;
CREATE TABLE t1(time TIMESTAMP, c1 BIGINT);
INSERT INTO t1(time, c1) VALUES (1641024000000, 1);

# query 1
SELECT c1 FROM t1 WHERE time IN (1) AND time BETWEEN (1741024000000) AND (1741024000000);

Expected Behavior

Query 1 returned result set: empty set

Actual behaviour

Query 1 returned result set: 1

Environment

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

Additional Context

Hello, TDengine team. When the IN operator and the BETWEEN operator are used on the time field and connected by the AND logical operator, the expressions involving the IN and BETWEEN operators evaluate to FALSE, but the final result still filters out all the data.

No source file or test is named. Start by running the provided CREATE, INSERT, and SELECT statements against TDengine, then trace the expression evaluation for the time-field IN and BETWEEN predicates joined by AND. Done means the query returns an empty result set, with a regression test covering this case.