Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4.11, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
-
None
-
Ubuntu 19.04
Description
Hi everyone,
On the latest trunk version (0308de9), I could observe a bug, as demonstrated by the following test case:
CREATE TABLE t0(c0 INT);
|
INSERT INTO t0 VALUES (1);
|
CREATE INDEX i0 ON t0(c0);
|
SELECT * FROM t0 WHERE 0.5 = c0; -- unexpected: row is fetched
|
Only when the index is created does MariaDB compute an incorrect result set, containing the row. As demonstrated below, the expression should evaluate to FALSE:
SELECT 0.5 = c0 FROM t0; -- evaluates to FALSE
|