1
-- source include/have_latin2_ch.inc
4
# Tests with latin2_czech_cs
7
drop table if exists t1;
11
# Bug#17374: select ... like 'A%' operator fails
12
# to find value on columuns with key
15
select 'A' = 'a' collate latin2_czech_cs;
19
) character set latin2 collate latin2_czech_cs;
20
insert into t1 values (1,'Aa');
21
insert into t1 values (2,'Aas');
22
alter table t1 add primary key aaa(tt);
23
select * from t1 where tt like 'Aa%';
24
select * from t1 ignore index (primary) where tt like 'Aa%';
25
select * from t1 where tt like '%Aa%';
26
select * from t1 where tt like 'AA%';
27
select * from t1 ignore index (primary) where tt like 'AA%';
28
select * from t1 where tt like '%AA%';