1
# Tests for Column list which requires utf8 output
2
--source include/have_partition.inc
4
create table t1 (a varchar(2) character set cp1250)
5
partition by list columns (a)
6
( partition p0 values in (0x81));
9
create table t1 (a varchar(2) character set cp1250)
10
partition by list columns (a)
11
( partition p0 values in (0x80));
16
# BUG#48164, too long partition fields causes crash
18
--error ER_PARTITION_FIELDS_TOO_LONG
19
create table t1 (a varchar(1500), b varchar(1570))
20
partition by list columns(a,b)
21
( partition p0 values in (('a','b')));
23
create table t1 (a varchar(1023) character set utf8 collate utf8_spanish2_ci)
24
partition by range columns(a)
25
( partition p0 values less than ('CZ'),
26
partition p1 values less than ('CH'),
27
partition p2 values less than ('D'));
28
insert into t1 values ('czz'),('chi'),('ci'),('cg');
29
select * from t1 where a between 'cg' AND 'ci';
33
# BUG#48163, Dagger in UCS2 not working as partition value
35
create table t1 (a varchar(2) character set ucs2)
36
partition by list columns (a)
37
(partition p0 values in (0x2020),
38
partition p1 values in (''));
40
insert into t1 values ('');
41
insert into t1 values (_ucs2 0x2020);