Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11.2, 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
ubuntu 20.04 LTS
Description
I deploy MariaDB with version 10.11.2 in docker and run the following statements.
I doubt the SELECT statement may return an incorrect result.
CREATE TABLE t1 (c1 INT); |
INSERT INTO t1 VALUES (1); |
|
|
SELECT c1 FROM t1 WHERE (! (! -1)) NOT IN (1); -- actual: 1, expected: 0 |
SELECT c1 FROM t1 WHERE (! (! -1)) LIKE (1); -- actual: 0, expected: 1 |
|
|
SELECT (! (! -1)) NOT IN (1); -- 0 |
SELECT (! (! -1)) LIKE (1); -- 1 |