diff options
| author | Mikael Ronstrom <mikael@mysql.com> | 2009-10-21 20:04:34 +0200 |
|---|---|---|
| committer | Mikael Ronstrom <mikael@mysql.com> | 2009-10-21 20:04:34 +0200 |
| commit | e30ccf7a6772f52f1357d5e7ddba61660c9f73b8 (patch) | |
| tree | 9f9a8ea4d4acd71a4326343ce9da44073ec93d76 /mysql-test/r/partition_range.result | |
| parent | 9ef69958c5f9c0078b6e440cc2730c459d40964f (diff) | |
| download | mariadb-git-e30ccf7a6772f52f1357d5e7ddba61660c9f73b8.tar.gz | |
Fixed Information schema for column list partitioned tables
Diffstat (limited to 'mysql-test/r/partition_range.result')
| -rw-r--r-- | mysql-test/r/partition_range.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/partition_range.result b/mysql-test/r/partition_range.result index 237d026fe6e..4e18c9668e9 100644 --- a/mysql-test/r/partition_range.result +++ b/mysql-test/r/partition_range.result @@ -9,6 +9,11 @@ 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"; +partition_method partition_expression partition_description +RANGE TO_SECONDS(a) 63340531200 +RANGE TO_SECONDS(a) 63342604800 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'; |