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