diff options
author | unknown <holyfoot@mysql.com> | 2006-03-20 19:22:56 +0400 |
---|---|---|
committer | unknown <holyfoot@mysql.com> | 2006-03-20 19:22:56 +0400 |
commit | 6315e46af2e88b694fdd15abbd4fa637fbd21bf4 (patch) | |
tree | 9e913ba8bf17fc3e0b4ed769ff19b428d5eacf45 /mysql-test/r | |
parent | 851f4fb9545fd7b44f222eff294937e2f2d6871e (diff) | |
parent | 91eac0bdc3b212967f73e221463e8173686863ca (diff) | |
download | mariadb-git-6315e46af2e88b694fdd15abbd4fa637fbd21bf4.tar.gz |
merging
sql/sql_partition.cc:
Auto merged
Diffstat (limited to 'mysql-test/r')
-rw-r--r-- | mysql-test/r/partition.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/partition.result b/mysql-test/r/partition.result index 4ef61745cda..df15a5652e0 100644 --- a/mysql-test/r/partition.result +++ b/mysql-test/r/partition.result @@ -557,6 +557,12 @@ t2 CREATE TABLE `t2` ( PRIMARY KEY (`a`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='no comment' PARTITION BY KEY (a) drop table t2; +create table t1 (s1 char(2) character set utf8) +partition by list (case when s1 > 'cz' then 1 else 2 end) +(partition p1 values in (1), +partition p2 values in (2)); +drop table t1; +create table t1 (f1 int) partition by hash (f1) as select 1; prepare stmt1 from 'create table t1 (s1 int) partition by hash (s1)'; execute stmt1; execute stmt1; |