1#
2# Test for character set related things in combination
3# with the partition storage engine
4#
5-- source include/have_partition.inc
6
7--disable_warnings
8drop table if exists t1;
9--enable_warnings
10
11set names utf8;
12create table t1 (s1 int)
13  partition by list (s1)
14    (partition c values in (1),
15     partition Ç values in (3));
16insert into t1 values (1),(3);
17select * from t1;
18flush tables;
19set names latin1;
20select * from t1;
21drop table t1;
22
23-- error ER_PARTITION_FUNCTION_IS_NOT_ALLOWED
24create table t1 (a varchar(1), primary key (a))
25partition by list (ascii(a))
26(partition p1 values in (65));
27#insert into t1 values ('A');
28#replace into t1 values ('A');
29#drop table t1;
30