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 | 80c91e429876e66dfac0c288c8e390b553b5fb49 (patch) | |
tree | c54cce7e6f502a73331b395334f2ddd5b948280b /mysql-test/r/partition_innodb.result | |
parent | 4bf2c41df4ea0d62ce6b66da155988aafe2328ba (diff) | |
parent | 7ee331ab5d35e0d428cebf56a385627f2c65f76c (diff) | |
download | mariadb-git-80c91e429876e66dfac0c288c8e390b553b5fb49.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; |