diff options
| author | Mikael Ronstrom <mikael@mysql.com> | 2009-10-21 20:11:27 +0200 |
|---|---|---|
| committer | Mikael Ronstrom <mikael@mysql.com> | 2009-10-21 20:11:27 +0200 |
| commit | 540015aac8f486617ee515623ccee2a70c845019 (patch) | |
| tree | b40509a191286d38e9bb35c1bd7202d57294e96d /mysql-test/t/partition_range.test | |
| parent | 3903aada9bfc0b03156d3810b802807b4075ecb7 (diff) | |
| parent | e30ccf7a6772f52f1357d5e7ddba61660c9f73b8 (diff) | |
| download | mariadb-git-540015aac8f486617ee515623ccee2a70c845019.tar.gz | |
Merge
Diffstat (limited to 'mysql-test/t/partition_range.test')
| -rw-r--r-- | mysql-test/t/partition_range.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/partition_range.test b/mysql-test/t/partition_range.test index a6d73df5939..b4de6f1e5f6 100644 --- a/mysql-test/t/partition_range.test +++ b/mysql-test/t/partition_range.test @@ -21,6 +21,8 @@ create table t1 (a datetime not null) partition by range (TO_SECONDS(a)) ( partition p0 VALUES LESS THAN (TO_SECONDS('2007-03-08 00:00:00')), partition p1 VALUES LESS THAN (TO_SECONDS('2007-04-01 00:00:00'))); +select partition_method, partition_expression, partition_description + from information_schema.partitions where table_name = "t1"; INSERT INTO t1 VALUES ('2007-03-01 12:00:00'), ('2007-03-07 12:00:00'); INSERT INTO t1 VALUES ('2007-03-08 12:00:00'), ('2007-03-15 12:00:00'); explain partitions select * from t1 where a < '2007-03-08 00:00:00'; |