diff options
| author | Mattias Jonsson <mattias.jonsson@sun.com> | 2009-11-17 22:47:34 +0100 |
|---|---|---|
| committer | Mattias Jonsson <mattias.jonsson@sun.com> | 2009-11-17 22:47:34 +0100 |
| commit | 98fd304278ca029b56671412e8bec72ed4f17537 (patch) | |
| tree | 6f2dd10473bcf1b21fbdda0cf83e455293fedc9d /mysql-test/r/partition.result | |
| parent | c4584fc6d40a6a673e7a46750b575effddef6207 (diff) | |
| download | mariadb-git-98fd304278ca029b56671412e8bec72ed4f17537.tar.gz | |
backport of bug#45904 from mysql-pe to 5.1
sql/sql_partition.cc:
Bug#45904 Used list_of_part_fields instead of list_of_subpart_fields to discover if KEY subpartitioning => caused failure when charset=utf8 even for subpartitioning by key, would also allow for subpartitioning by hash with utf8 erroneously
Diffstat (limited to 'mysql-test/r/partition.result')
| -rw-r--r-- | mysql-test/r/partition.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/partition.result b/mysql-test/r/partition.result index 6611d39628f..425f1e85d00 100644 --- a/mysql-test/r/partition.result +++ b/mysql-test/r/partition.result @@ -50,6 +50,13 @@ t1 CREATE TABLE `t1` ( PARTITION p3 VALUES LESS THAN (733969) ENGINE = MyISAM, PARTITION pmax VALUES LESS THAN MAXVALUE ENGINE = MyISAM) */ DROP TABLE t1; +create table t1 (a int NOT NULL, b varchar(5) NOT NULL) +default charset=utf8 +partition by list (a) +subpartition by key (b) +(partition p0 values in (1), +partition p1 values in (2)); +drop table t1; create table t1 (a int, b int, key(a)) partition by list (a) ( partition p0 values in (1), |