1--echo # 2--echo # MDEV-14350 Index use with collation utf8mb4_unicode_nopad_ci on LIKE pattern with wrong results 3--echo # 4 5CREATE OR REPLACE TABLE t1 AS SELECT SPACE(50) AS a, SPACE (50) AS b; 6ALTER TABLE t1 ADD KEY(a), ADD KEY(b); 7SHOW CREATE TABLE t1; 8INSERT INTO t1 VALUES ('111', '111'); 9INSERT INTO t1 VALUES ('222', '222'); 10INSERT INTO t1 VALUES ('333', '333'); 11INSERT INTO t1 VALUES ('444', '444'); 12SELECT * FROM t1 WHERE a LIKE '111%'; 13SELECT * FROM t1 IGNORE INDEX (a) WHERE a LIKE '111%'; 14DROP TABLE t1; 15