diff options
author | mikael/pappa@dator5.(none) <> | 2006-08-02 07:01:38 -0400 |
---|---|---|
committer | mikael/pappa@dator5.(none) <> | 2006-08-02 07:01:38 -0400 |
commit | fbd15d253d8b76c26695e953c81b341c8ecf1001 (patch) | |
tree | f18a764bff80f479eb18d1517215d1160a408a07 /mysql-test/r/partition_pruning.result | |
parent | ae052828012d3635d958fdec08f1769361ceb4f2 (diff) | |
parent | 6425e335304b50749ca9775b9c015d21417c9b73 (diff) | |
download | mariadb-git-fbd15d253d8b76c26695e953c81b341c8ecf1001.tar.gz |
Merge dator5.(none):/home/pappa/clean-mysql-5.1
into dator5.(none):/home/pappa/bug18198
Diffstat (limited to 'mysql-test/r/partition_pruning.result')
-rw-r--r-- | mysql-test/r/partition_pruning.result | 12 |
1 files changed, 3 insertions, 9 deletions
diff --git a/mysql-test/r/partition_pruning.result b/mysql-test/r/partition_pruning.result index c7f1861f6b1..5fc0058356d 100644 --- a/mysql-test/r/partition_pruning.result +++ b/mysql-test/r/partition_pruning.result @@ -284,13 +284,6 @@ explain partitions select * from t9 where a <= '2004-12-19'; id select_type table partitions type possible_keys key key_len ref rows Extra 1 SIMPLE t9 p0,p1 ALL NULL NULL NULL NULL 2 Using where drop table t5,t6,t7,t8,t9; -create table t1 (a enum('a','b','c','d') default 'a') -partition by hash (ascii(a)) partitions 2; -insert into t1 values ('a'),('b'),('c'); -explain partitions select * from t1 where a='b'; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p0,p1 ALL NULL NULL NULL NULL 3 Using where -drop table t1; create table t1 ( a1 int not null ) @@ -683,8 +676,9 @@ f_int1 f_int2 8 8 9 9 drop table t1; -create table t1 (a char(10)) partition by list(length(a)) ( -partition p1 values in (1), +create table t1 (a char(10) binary) +partition by list(length(a)) +(partition p1 values in (1), partition p2 values in (2), partition p3 values in (3), partition p4 values in (4), |