mysql-test/suite/ibmdb2i/t/ibmdb2i_bug_45196.test


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

source suite/ibmdb2i/include/have_ibmdb2i.inc;
source suite/ibmdb2i/include/have_i61.inc;

--disable_warnings
drop table if exists t1;
--enable_warnings

create table t1 (c char(10), index(c)) collate ucs2_czech_ci engine=ibmdb2i;
insert into t1 values ("ch"),("h"),("i");
select * from t1 order by c;
drop table t1;

create table t1 (c char(10), index(c)) collate utf8_czech_ci engine=ibmdb2i;
insert into t1 values ("ch"),("h"),("i");
select * from t1 order by c;
drop table t1;

create table t1 (c char(10), index(c)) collate ucs2_danish_ci engine=ibmdb2i;           
insert into t1 values("abc"),("abcd"),("aaaa"); 
select c from t1 order by c;
drop table t1;

create table t1 (c char(10), index(c)) collate utf8_danish_ci engine=ibmdb2i;           
insert into t1 values("abc"),("abcd"),("aaaa"); 
select c from t1 order by c;
drop table t1;