diff options
Diffstat (limited to 'mysql-test/main/partition_charset.result')
-rw-r--r-- | mysql-test/main/partition_charset.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/main/partition_charset.result b/mysql-test/main/partition_charset.result new file mode 100644 index 00000000..f8f75e8b --- /dev/null +++ b/mysql-test/main/partition_charset.result @@ -0,0 +1,22 @@ +drop table if exists t1; +set names utf8; +create table t1 (s1 int) +partition by list (s1) +(partition c values in (1), +partition Ç values in (3)); +insert into t1 values (1),(3); +select * from t1; +s1 +1 +3 +flush tables; +set names latin1; +select * from t1; +s1 +1 +3 +drop table t1; +create table t1 (a varchar(1), primary key (a)) +partition by list (ascii(a)) +(partition p1 values in (65)); +ERROR HY000: This partition function is not allowed |