diff options
| author | Mikael Ronstrom <mikael@mysql.com> | 2009-10-21 13:59:11 +0200 |
|---|---|---|
| committer | Mikael Ronstrom <mikael@mysql.com> | 2009-10-21 13:59:11 +0200 |
| commit | 10210bfef2e16f9a2033bf6444bb18a121f989a1 (patch) | |
| tree | 8072ec9cc4bcff99fea892a535c03e50f8e32316 /mysql-test/r/partition_range.result | |
| parent | bbd922b09c94bafb18e583a00865750164358736 (diff) | |
| parent | 9ef69958c5f9c0078b6e440cc2730c459d40964f (diff) | |
| download | mariadb-git-10210bfef2e16f9a2033bf6444bb18a121f989a1.tar.gz | |
Merge
Diffstat (limited to 'mysql-test/r/partition_range.result')
| -rw-r--r-- | mysql-test/r/partition_range.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/partition_range.result b/mysql-test/r/partition_range.result index 44e76f8751e..27477b0b59b 100644 --- a/mysql-test/r/partition_range.result +++ b/mysql-test/r/partition_range.result @@ -833,7 +833,7 @@ a EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a >= '2004-07-01' AND a <= '2004-09-30'; id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p407,p408,p409 ALL NULL NULL NULL NULL 9 Using where +1 SIMPLE t1 p3xx,p407,p408,p409 ALL NULL NULL NULL NULL 18 Using where SELECT * from t1 WHERE (a >= '2004-07-01' AND a <= '2004-09-30') OR (a >= '2005-07-01' AND a <= '2005-09-30'); @@ -860,7 +860,7 @@ EXPLAIN PARTITIONS SELECT * from t1 WHERE (a >= '2004-07-01' AND a <= '2004-09-30') OR (a >= '2005-07-01' AND a <= '2005-09-30'); id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p407,p408,p409,p507,p508,p509 ALL NULL NULL NULL NULL 18 Using where +1 SIMPLE t1 p3xx,p407,p408,p409,p507,p508,p509 ALL NULL NULL NULL NULL 27 Using where DROP TABLE t1; create table t1 (a int); insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); |