diff options
| author | Mattias Jonsson <mattias.jonsson@oracle.com> | 2011-06-13 11:57:47 +0200 |
|---|---|---|
| committer | Mattias Jonsson <mattias.jonsson@oracle.com> | 2011-06-13 11:57:47 +0200 |
| commit | 775770145c904f48949c5c0e95d594d8f222eb32 (patch) | |
| tree | e9f7dcaea07cffd1d7bace5e923414f1430c3d19 /mysql-test/t/partition.test | |
| parent | e827b51fa0a8e7aefd7d38f19725452b15803dfe (diff) | |
| parent | d53906e3872016cb06f48a80557fb8edda59b691 (diff) | |
| download | mariadb-git-775770145c904f48949c5c0e95d594d8f222eb32.tar.gz | |
merge
Diffstat (limited to 'mysql-test/t/partition.test')
| -rw-r--r-- | mysql-test/t/partition.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/partition.test b/mysql-test/t/partition.test index 7d7b7a2cc54..2a8ba15d3f1 100644 --- a/mysql-test/t/partition.test +++ b/mysql-test/t/partition.test @@ -227,10 +227,16 @@ INSERT INTO t1 VALUES ('2009-07-14 17:35:55', 'pmax'); INSERT INTO t1 VALUES ('2009-09-21 17:31:42', 'pmax'); SELECT * FROM t1; +SELECT * FROM t1 where a between '2007-01-01' and '2007-08-01'; +EXPLAIN PARTITIONS SELECT * FROM t1 where a between '2007-01-01' and '2007-08-01'; +EXPLAIN PARTITIONS SELECT * FROM t1 where a = '2007-07-30 17:35:48'; ALTER TABLE t1 REORGANIZE PARTITION pmax INTO ( PARTITION p3 VALUES LESS THAN (1247688000), PARTITION pmax VALUES LESS THAN MAXVALUE); SELECT * FROM t1; +SELECT * FROM t1 where a between '2007-01-01' and '2007-08-01'; +EXPLAIN PARTITIONS SELECT * FROM t1 where a between '2007-01-01' and '2007-08-01'; +EXPLAIN PARTITIONS SELECT * FROM t1 where a = '2007-07-30 17:35:48'; SHOW CREATE TABLE t1; DROP TABLE t1; |