diff options
| author | Mattias Jonsson <mattias.jonsson@oracle.com> | 2011-03-16 11:59:01 +0100 |
|---|---|---|
| committer | Mattias Jonsson <mattias.jonsson@oracle.com> | 2011-03-16 11:59:01 +0100 |
| commit | d53906e3872016cb06f48a80557fb8edda59b691 (patch) | |
| tree | cea140d8d7b63bf9d57e1b8efda833a7a008cc7d /mysql-test/t/partition.test | |
| parent | 378091e434d66dcc7081f991a07db2244dbb8cda (diff) | |
| download | mariadb-git-d53906e3872016cb06f48a80557fb8edda59b691.tar.gz | |
Bug#11746819:
Bug#28928: UNIX_TIMESTAMP() should be considered unary monotonic by partition pruning
Made UNIX_TIMESTAMP MONOTONIC_INCREASING when it have TIMESTAMP argument (only).
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 0151820cef9..0630dd31714 100644 --- a/mysql-test/t/partition.test +++ b/mysql-test/t/partition.test @@ -112,10 +112,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; |