Details
Description
Run the following statement, in which the first query returns an incorrect query result.
CREATE TABLE t1 (c1 float, KEY i1 (c1)); |
INSERT INTO t1(c1) VALUES (-9.183); |
SELECT c1 FROM t1 WHERE (BINARY c1) NOT IN (SELECT c1 FROM t1 USE INDEX (i1)); -- actual:{}, expected: {-9.183} |