Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.7
-
None
Description
CREATE TABLE t (c char(32), KEY (c)) ENGINE=MyISAM collate geostd8_nopad_bin; |
INSERT INTO t VALUES ('r'),('rock'),('rr'); |
SELECT c FROM t WHERE c LIKE 'r%'; |
 |
# Cleanup
|
DROP TABLE t; |
10.5 2776635c |
SELECT c FROM t WHERE c LIKE 'r%'; |
c
|
rock
|
rr
|
Same with geostd8_general_nopad_ci collation, but not, for example, with geostd8_general_ci.
Since it only happens with a key, I don't suppose it's a feature of these collations.
Reproducible on 10.5+ with MyISAM and Aria.
Not reproducible on 10.4.
Not reproducible with InnoDB.