diff options
author | Alexander Nozdrin <alik@sun.com> | 2009-09-16 10:52:43 +0400 |
---|---|---|
committer | Alexander Nozdrin <alik@sun.com> | 2009-09-16 10:52:43 +0400 |
commit | df0dcab43744c3c78beddaa2fcd9a87a7abe1022 (patch) | |
tree | c54cce7e6f502a73331b395334f2ddd5b948280b /mysql-test/r/partition_innodb.result | |
parent | 6fbb712fed26516a3152028e71125bf147bcb8a8 (diff) | |
parent | 16d8401a2897258c94bb741110c59e534d2d637c (diff) | |
download | mariadb-git-df0dcab43744c3c78beddaa2fcd9a87a7abe1022.tar.gz |
Merge from mysql-5.1-bugteam.
Diffstat (limited to 'mysql-test/r/partition_innodb.result')
-rw-r--r-- | mysql-test/r/partition_innodb.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/partition_innodb.result b/mysql-test/r/partition_innodb.result index af277e5ce40..4323d167b10 100644 --- a/mysql-test/r/partition_innodb.result +++ b/mysql-test/r/partition_innodb.result @@ -1,4 +1,18 @@ drop table if exists t1; +create table t1 (a int not null, +b datetime not null, +primary key (a,b)) +engine=innodb +partition by range (to_days(b)) +subpartition by hash (a) +subpartitions 2 +( partition p0 values less than (to_days('2009-01-01')), +partition p1 values less than (to_days('2009-02-01')), +partition p2 values less than (to_days('2009-03-01')), +partition p3 values less than maxvalue); +alter table t1 reorganize partition p1,p2 into +( partition p2 values less than (to_days('2009-03-01'))); +drop table t1; CREATE TABLE t1 (id INT PRIMARY KEY, data INT) ENGINE = InnoDB PARTITION BY RANGE(id) ( PARTITION p0 VALUES LESS THAN (5), @@ -250,3 +264,7 @@ SUBPARTITION BY KEY (char_column) SUBPARTITIONS 2 (PARTITION p1 VALUES LESS THAN (5) ENGINE = MyISAM) */ drop table t1; +CREATE TABLE t1 (a INT) ENGINE=InnoDB +PARTITION BY list(a) (PARTITION p1 VALUES IN (1)); +CREATE INDEX i1 ON t1 (a); +DROP TABLE t1; |