1SELECT @@collation_connection;
2--echo #
3--echo # Bug#57737 Character sets: search fails with like, contraction, index
4--echo #
5CREATE TABLE t1 AS SELECT REPEAT(' ', 10) AS s1 LIMIT 0;
6INSERT INTO t1 VALUES ('c'),('ce'),('cé'),('ch');
7SELECT * FROM t1 WHERE s1 LIKE 'c%';
8ALTER TABLE t1 ADD KEY s1 (s1);
9SELECT * FROM t1 WHERE s1 LIKE 'c%';
10ALTER TABLE t1 DROP KEY s1, ADD KEY(s1(1));
11SELECT * FROM t1 WHERE s1 LIKE 'ch';
12DROP TABLE t1;
13