1SELECT @@collation_connection;
2--echo #
3--echo # Bug#57737 Character sets: search fails with like, contraction, index
4--echo # Part#2 - ignorable characters
5--echo #
6CREATE TABLE t1 AS SELECT REPEAT(' ', 10) AS s1 LIMIT 0;
7INSERT INTO t1 VALUES ('a\0\0\0\0\0\t'),('a'),('b'),('c'),('d'),('e');
8SELECT HEX(s1) FROM t1 WHERE s1 LIKE 'a%';
9ALTER TABLE t1 ADD KEY s1 (s1);
10SELECT HEX(s1) FROM t1 WHERE s1 LIKE 'a%';
11DROP TABLE t1;
12