Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL), 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
-
Not for Release Notes
Description
This script correctly returns one row:
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET latin1);
|
INSERT INTO t1 VALUES ('a'),('a\t'),('az'),('b'),('c'),('d'),('e');
|
SELECT * FROM t1 WHERE a<'a';
|
+------+
|
| a |
|
+------+
|
| a |
|
+------+
|
1 row in set (0.00 sec)
|
Now if I add a prefix index and re-run the select query:
ALTER TABLE t1 ADD KEY a(a(1));
|
SELECT * FROM t1 WHERE a<'a';
|
it erroneously returns empty set.