diff options
| author | Mikael Ronstrom <mikael@mysql.com> | 2009-11-02 11:03:40 +0100 |
|---|---|---|
| committer | Mikael Ronstrom <mikael@mysql.com> | 2009-11-02 11:03:40 +0100 |
| commit | 6ce3a06febae181f598bef357bb7c1bf08571572 (patch) | |
| tree | 6a8f5d1e858ae1cb4107e6c0213270ae3a46e47c /mysql-test/r/partition_column.result | |
| parent | 1f94bbc78eba29443c66082380cfd78c33d1abaf (diff) | |
| download | mariadb-git-6ce3a06febae181f598bef357bb7c1bf08571572.tar.gz | |
Added test case for UTF8 strings in partition constants
Diffstat (limited to 'mysql-test/r/partition_column.result')
| -rw-r--r-- | mysql-test/r/partition_column.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/partition_column.result b/mysql-test/r/partition_column.result index 9da880d5cfa..71d159c2f51 100644 --- a/mysql-test/r/partition_column.result +++ b/mysql-test/r/partition_column.result @@ -28,6 +28,15 @@ create table t1 (a varchar(2) character set ucs2) partition by list columns (a) (partition p0 values in (0x2020), partition p1 values in ('')); +set names utf8; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(2) CHARACTER SET ucs2 DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +/*!50100 PARTITION BY LIST COLUMNS(a) +(PARTITION p0 VALUES IN ('†') ENGINE = MyISAM, + PARTITION p1 VALUES IN ('') ENGINE = MyISAM) */ insert into t1 values (''); insert into t1 values (_ucs2 0x2020); drop table t1; |