summaryrefslogtreecommitdiff
path: root/mysql-test/r
diff options
context:
space:
mode:
authorunknown <holyfoot@mysql.com>2006-03-20 19:22:56 +0400
committerunknown <holyfoot@mysql.com>2006-03-20 19:22:56 +0400
commit6315e46af2e88b694fdd15abbd4fa637fbd21bf4 (patch)
tree9e913ba8bf17fc3e0b4ed769ff19b428d5eacf45 /mysql-test/r
parent851f4fb9545fd7b44f222eff294937e2f2d6871e (diff)
parent91eac0bdc3b212967f73e221463e8173686863ca (diff)
downloadmariadb-git-6315e46af2e88b694fdd15abbd4fa637fbd21bf4.tar.gz
merging
sql/sql_partition.cc: Auto merged
Diffstat (limited to 'mysql-test/r')
-rw-r--r--mysql-test/r/partition.result6
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;