Skip to content

Commit 70c5fe2

Browse files
author
Mattias Jonsson
committed
merge
--BZR-- revision-id: [email protected] property-branch-nick: topush-5.5 testament3-sha1: ad1054472e32d8a308999562382c81e88a0d03cd
2 parents 0bb707c + f8ad584 commit 70c5fe2

File tree

6 files changed

+1356
-0
lines changed

6 files changed

+1356
-0
lines changed

‎mysql-test/r/partition.result‎

Lines changed: 18 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -218,6 +218,15 @@ a b
218218
2007-07-30 17:35:48 p1
219219
2009-07-14 17:35:55 pmax
220220
2009-09-21 17:31:42 pmax
221+
SELECT * FROM t1 where a between '2007-01-01' and '2007-08-01';
222+
a b
223+
2007-07-30 17:35:48 p1
224+
EXPLAIN PARTITIONS SELECT * FROM t1 where a between '2007-01-01' and '2007-08-01';
225+
id select_type table partitions type possible_keys key key_len ref rows Extra
226+
1 SIMPLE t1 p1 system PRIMARY NULL NULL NULL 1
227+
EXPLAIN PARTITIONS SELECT * FROM t1 where a = '2007-07-30 17:35:48';
228+
id select_type table partitions type possible_keys key key_len ref rows Extra
229+
1 SIMPLE t1 p1 system PRIMARY NULL NULL NULL 1
221230
ALTER TABLE t1 REORGANIZE PARTITION pmax INTO (
222231
PARTITION p3 VALUES LESS THAN (1247688000),
223232
PARTITION pmax VALUES LESS THAN MAXVALUE);
@@ -226,6 +235,15 @@ a b
226235
2007-07-30 17:35:48 p1
227236
2009-07-14 17:35:55 pmax
228237
2009-09-21 17:31:42 pmax
238+
SELECT * FROM t1 where a between '2007-01-01' and '2007-08-01';
239+
a b
240+
2007-07-30 17:35:48 p1
241+
EXPLAIN PARTITIONS SELECT * FROM t1 where a between '2007-01-01' and '2007-08-01';
242+
id select_type table partitions type possible_keys key key_len ref rows Extra
243+
1 SIMPLE t1 p1 system PRIMARY NULL NULL NULL 1
244+
EXPLAIN PARTITIONS SELECT * FROM t1 where a = '2007-07-30 17:35:48';
245+
id select_type table partitions type possible_keys key key_len ref rows Extra
246+
1 SIMPLE t1 p1 system PRIMARY NULL NULL NULL 1
229247
SHOW CREATE TABLE t1;
230248
Table Create Table
231249
t1 CREATE TABLE `t1` (

0 commit comments

Comments
 (0)