diff options
| author | Mikael Ronstrom <mikael@mysql.com> | 2009-10-21 12:57:33 +0200 |
|---|---|---|
| committer | Mikael Ronstrom <mikael@mysql.com> | 2009-10-21 12:57:33 +0200 |
| commit | 9ef69958c5f9c0078b6e440cc2730c459d40964f (patch) | |
| tree | f0b0fae716640619475cf5f3d5363d0ca84f609e /mysql-test/r/partition_range.result | |
| parent | 6e7a37d3e8fc1f32c382dae143eb091be1eb1e8f (diff) | |
| parent | 37b6043070ebed97158c4ef9e3c8534a8c23c860 (diff) | |
| download | mariadb-git-9ef69958c5f9c0078b6e440cc2730c459d40964f.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 a3d02b66c0a..237d026fe6e 100644 --- a/mysql-test/r/partition_range.result +++ b/mysql-test/r/partition_range.result @@ -834,7 +834,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'); @@ -861,7 +861,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); |