1#
2# Bug#32510 LIKE search fails with indexed 'eucjpms' and 'ujis' char column
3#
4# Testing my_ctype_like_range_xxx
5# (used in LIKE optimization for an indexed column)
6#
7
8# Create table using @@character_set_connection and @@collation_connection
9# for the string columns.
10
11CREATE TABLE t1 AS
12SELECT 10 AS a, REPEAT('a',20) AS b, REPEAT('a',8) AS c, REPEAT('a',8) AS d;
13ALTER TABLE t1 ADD PRIMARY KEY(a), ADD KEY(b);
14
15INSERT INTO t1 (a, b) VALUES (1, repeat(0xF1F2,5));
16INSERT INTO t1 (a, b) VALUES (2, repeat(0xF1F2,10));
17INSERT INTO t1 (a, b) VALUES (3, repeat(0xF1F2,11));
18INSERT INTO t1 (a, b) VALUES (4, repeat(0xF1F2,12));
19
20# Check pattern (important for ucs2, utf16, utf32)
21SELECT hex(concat(repeat(0xF1F2, 10), '%'));
22
23--echo 3 rows expected
24SELECT a, hex(b), c FROM t1 WHERE b LIKE concat(repeat(0xF1F2,10), '%');
25DROP TABLE t1;
26