diff options
author | Mikael Ronstrom <mikael@mysql.com> | 2009-11-02 14:49:26 +0100 |
---|---|---|
committer | Mikael Ronstrom <mikael@mysql.com> | 2009-11-02 14:49:26 +0100 |
commit | 8755de32abe3933d0d158801184e7798d39cc44d (patch) | |
tree | 838f6e5fc076209096b887360145850f326f706b /mysql-test/r/partition_column.result | |
parent | 1c91799c6a4c9e00be87222907a6749d2bac2eff (diff) | |
download | mariadb-git-8755de32abe3933d0d158801184e7798d39cc44d.tar.gz |
Fixed a few bugs in hex string generation, in call to val_str for partition expressions, also made code reusable for DEFAULT handling to fix BUG#48464 by introducing function get_cs_converted_string_value, added partition_utf8 test case for UTF8 outputs
Diffstat (limited to 'mysql-test/r/partition_column.result')
-rw-r--r-- | mysql-test/r/partition_column.result | 44 |
1 files changed, 14 insertions, 30 deletions
diff --git a/mysql-test/r/partition_column.result b/mysql-test/r/partition_column.result index 71d159c2f51..8c7d5b4ff77 100644 --- a/mysql-test/r/partition_column.result +++ b/mysql-test/r/partition_column.result @@ -1,18 +1,18 @@ drop table if exists t1; -create table t1 (a varchar(1500), b varchar(1570)) -partition by list columns(a,b) -( partition p0 values in (('a','b'))); -ERROR HY000: The total length of the partitioning fields is too large -create table t1 (a varchar(1023) character set utf8 collate utf8_spanish2_ci) -partition by range columns(a) -( partition p0 values less than ('CZ'), -partition p1 values less than ('CH'), -partition p2 values less than ('D')); -insert into t1 values ('czz'),('chi'),('ci'),('cg'); -select * from t1 where a between 'cg' AND 'ci'; -a -ci -cg +create table t1 (a varchar(5)) +partition by list columns(a) +( partition p0 values in ('\''), + partition p1 values in ('\\'), + partition p2 values in ('\0')); +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(5) 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, + PARTITION p2 VALUES IN ('\0') ENGINE = MyISAM) */ drop table t1; set @@sql_mode=allow_invalid_dates; create table t1 (a char, b char, c date) @@ -24,22 +24,6 @@ partition by range columns (a,b,c) ( partition p0 values less than (0,0,'3000-11-31')); ERROR HY000: Partition column values of incorrect type set @@sql_mode=''; -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; create table t1 (a int, b char(10), c varchar(25), d datetime) partition by range columns(a,b,c,d) subpartition by hash (to_seconds(d)) |