Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.11, 11.4, 11.8, 12.3, 11.8.5
Description
Steps to reproduce
DROP DATABASE IF EXISTS fuzzDatabase;
CREATE DATABASE fuzzDatabase;
USE fuzzDatabase;
CREATE TABLE t0 (
c0 DOUBLE DEFAULT NULL
);
INSERT INTO t0 VALUES (1067779538);
INSERT INTO t0 VALUES (608648654);
INSERT INTO t0 VALUES (2127310953);
SELECT t0.c0 FROM t0 WHERE ((! (t0.c0 LIKE t0.c0)) NOT IN ((t0.c0 LIKE t0.c0)));
Actual result: Empty set (0.00 sec)
Expected result:
The query should return all 3 rows because:
t0.c0 LIKE t0.c0 evaluates to TRUE (1) for non-null values
! (TRUE) evaluates to FALSE (0)
0 NOT IN (1) is TRUE → rows should be returned
Attachments
Issue Links
- relates to
-
MDEV-36440 Double negation is treated as original value in WHERE clause
-
- Confirmed
-