diff options
| author | Mikael Ronstrom <mikael@mysql.com> | 2009-11-06 11:49:27 +0100 |
|---|---|---|
| committer | Mikael Ronstrom <mikael@mysql.com> | 2009-11-06 11:49:27 +0100 |
| commit | bf7771df3f8b797aa35a98881aa2d6891a4a6cf8 (patch) | |
| tree | c09e8e0f366a56f7f2a23b283baa2e5f9f3d7ea3 /mysql-test/r/partition_column.result | |
| parent | ca9fe97e9f050111227f3257172670a151431d83 (diff) | |
| download | mariadb-git-bf7771df3f8b797aa35a98881aa2d6891a4a6cf8.tar.gz | |
Review fixes for BUG#48161 and BUG#48447
Diffstat (limited to 'mysql-test/r/partition_column.result')
| -rw-r--r-- | mysql-test/r/partition_column.result | 29 |
1 files changed, 7 insertions, 22 deletions
diff --git a/mysql-test/r/partition_column.result b/mysql-test/r/partition_column.result index daed67b1cce..76faae968c6 100644 --- a/mysql-test/r/partition_column.result +++ b/mysql-test/r/partition_column.result @@ -1,5 +1,10 @@ drop table if exists t1; -create table t1 (a varchar(1) character set latin1 collate latin1_general_ci); +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 @@ -14,27 +19,7 @@ a b C c -create index i on t1 (a); -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 index i on t1; -alter table t1 -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')); +alter table t1 remove partitioning; select * from t1 where a > 'B' collate latin1_bin; a a |