-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.5, 10.1, 10.0
-
Fix Version/s: 10.1.7
-
Component/s: Optimizer
-
Labels:
SET NAMES latin1;
|
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a VARCHAR(10));
|
INSERT INTO t1 VALUES ('a'),('A');
|
SELECT * FROM t1 WHERE a IN ('a' COLLATE latin1_bin,'b');
|
SELECT * FROM t1 WHERE a IN ('a' COLLATE latin1_bin,'b') AND a='a';
|
The first SELECT correctly returns one row.
The second SELECT erroneously returns two rows. One row is expected.
The problem happens in equal field propagation.