The combination of the NOT operator and the IS NULL operator results in an error.

[LingweiKuang]

Bug Description

The combination of the NOT operator and the IS NULL operator returns an "Unexpected generic error."

To Reproduce

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

DROP TABLE t1;

CREATE TABLE IF NOT EXISTS t1( time TIMESTAMP, c0 BIGINT UNSIGNED );
INSERT INTO t1(time, c0) VALUES (1641024000000, NULL);

# query error
SELECT time, c0 FROM t1 WHERE NOT (c0 IS NULL);

Expected Behavior

The above query statements can be executed successfully.

Actual behaviour

This query statement returns an "Unexpected generic error" after execution.

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?

[yu285]

thanks for your feedback , we will check on this.

[yu285]

该问题已经修复，请升级验证，