diff options
| author | Mattias Jonsson <mattias.jonsson@sun.com> | 2009-10-19 12:09:52 +0200 |
|---|---|---|
| committer | Mattias Jonsson <mattias.jonsson@sun.com> | 2009-10-19 12:09:52 +0200 |
| commit | 26f21d6a09d2eb3b9b470523ef8225889fc99143 (patch) | |
| tree | 11acbcf83ba9f40be4d590a80de9558743535f17 /mysql-test/r/partition_range.result | |
| parent | 1fcf8de51b1ac3180d8e8453223f1f1edfbf73ef (diff) | |
| parent | cd5804ac7a3a7996883813b9e9b294a7f8688d28 (diff) | |
| download | mariadb-git-26f21d6a09d2eb3b9b470523ef8225889fc99143.tar.gz | |
Manual merge mysql-trunk -> mysql-trunk-wl3352
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); |