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