From 6ce3a06febae181f598bef357bb7c1bf08571572 Mon Sep 17 00:00:00 2001 From: Mikael Ronstrom Date: Mon, 2 Nov 2009 11:03:40 +0100 Subject: Added test case for UTF8 strings in partition constants --- mysql-test/r/partition_column.result | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'mysql-test/r/partition_column.result') 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; -- cgit v1.2.1