From e30ccf7a6772f52f1357d5e7ddba61660c9f73b8 Mon Sep 17 00:00:00 2001 From: Mikael Ronstrom Date: Wed, 21 Oct 2009 20:04:34 +0200 Subject: Fixed Information schema for column list partitioned tables --- mysql-test/t/partition_range.test | 2 ++ 1 file changed, 2 insertions(+) (limited to 'mysql-test/t/partition_range.test') diff --git a/mysql-test/t/partition_range.test b/mysql-test/t/partition_range.test index 741bae7b3cc..df4982298f9 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'; -- cgit v1.2.1