diff options
author | Alexander Nozdrin <alik@sun.com> | 2009-11-10 11:34:26 +0300 |
---|---|---|
committer | Alexander Nozdrin <alik@sun.com> | 2009-11-10 11:34:26 +0300 |
commit | ecd604717296518d1107362ae870bca226a0a6cc (patch) | |
tree | 2b510f70b2f2fee98a5d730b29194f09f4aab273 /mysql-test/r/partition_column.result | |
parent | b712dce3d57335d3957afe94d1c3200880aebe99 (diff) | |
parent | 6590cb3bd6de1979d6db92d55db740c28cc1a068 (diff) | |
download | mariadb-git-ecd604717296518d1107362ae870bca226a0a6cc.tar.gz |
Auto-merge from mysql-next-mr-alik.
Diffstat (limited to 'mysql-test/r/partition_column.result')
-rw-r--r-- | mysql-test/r/partition_column.result | 50 |
1 files changed, 50 insertions, 0 deletions
diff --git a/mysql-test/r/partition_column.result b/mysql-test/r/partition_column.result index 9d46c6e0805..249de9f3496 100644 --- a/mysql-test/r/partition_column.result +++ b/mysql-test/r/partition_column.result @@ -1,4 +1,54 @@ drop table if exists t1; +create table t1 (a varchar(1) character set latin1 collate latin1_general_ci) +partition by range columns(a) +( partition p0 values less than ('a'), +partition p1 values less than ('b'), +partition p2 values less than ('c'), +partition p3 values less than ('d')); +insert into t1 values ('A'),('a'),('B'),('b'),('C'),('c'); +select * from t1 where a > 'B' collate latin1_bin; +a +a +b +C +c +select * from t1 where a <> 'B' collate latin1_bin; +a +A +a +b +C +c +alter table t1 remove partitioning; +select * from t1 where a > 'B' collate latin1_bin; +a +a +b +C +c +select * from t1 where a <> 'B' collate latin1_bin; +a +A +a +b +C +c +drop table t1; +create table t1 (a varchar(2) character set latin1, +b varchar(2) character set latin1) +partition by list columns(a,b) +(partition p0 values in (('a','a'))); +insert into t1 values ('A','A'); +select * from t1 where b <> 'a' collate latin1_bin AND +a = 'A' collate latin1_bin; +a b +A A +alter table t1 remove partitioning; +select * from t1 where b <> 'a' collate latin1_bin AND +a = 'A' collate latin1_bin; +a b +A A +drop table t1; create table t1 (a varchar(5)) partition by list columns(a) ( partition p0 values in ('\''), |