
create table t0 (
  a varchar(100) 
) collate utf8mb3_czech_ci;

insert into t0 values ('c'), ('ch'),('d'),('e'),('h'),('i');



create table t1 (
  a varchar(100),
  index(a)
)collate utf8mb3_czech_ci;
insert into t1 select * from t0;

set optimizer_trace=1;
explain select * from t1 where a like 'c%';
select * from information_schema.optimizer_trace\G

explain select * from t1 where a like 'd%';
select * from information_schema.optimizer_trace\G

