bug: WHERE clause not working as expected with NOT

[malwaregarry]

Search before asking

• I had searched in the issues and found no similar issues.

Version

8.0.26-v1.2.453-d7c9a83f6b(rust-1.77.0-nightly-2024-05-06T12:12:40.122758622Z)

What's Wrong?

There seems to be a problem with chaining NOT operations and WHERE clause.

Example:

CREATE TABLE t0(c0 BOOLEAN);
INSERT INTO t0(c0) VALUES (false);

This query returns false

SELECT (NOT (NOT t0.c0)) from t0;

But it successfully selects the row in the table

SELECT t0.c0 FROM t0 WHERE (NOT (NOT t0.c0)); -- return 1  row

How to Reproduce?

CREATE TABLE t0(c0 BOOLEAN);
INSERT INTO t0(c0) VALUES (false);

SELECT t0.c0 FROM t0 WHERE (NOT t0.c0); -- return 1 row
SELECT t0.c0 FROM t0 WHERE (NOT (NOT t0.c0)); -- return 1 row


CREATE TABLE t1(c0 BOOLEAN);
INSERT INTO t1(c0) VALUES (true);

SELECT t1.c0 FROM t1 WHERE (NOT t1.c0); -- return 0 rows
SELECT t1.c0 FROM t1 WHERE (NOT (NOT t1.c0)); -- return 0 rows

Are you willing to submit PR?

• Yes I am willing to submit a PR!