Details
Description
In MariaDB, using NOT NOT t0.c0 in the WHERE clause may incorrectly filter out rows.
CREATE TABLE t0(c0 INT); |
INSERT INTO t0(c0) VALUES(2); |
|
|
/* should return the row (2), but returns empty set */
|
SELECT * FROM t0 WHERE (NOT NOT t0.c0) = 1; |
|
|
/* returns the row : (2) */
|
SELECT * FROM t0 WHERE (NOT NOT t0.c0) = 2; |