diff options
| author | unknown <holyfoot/hf@mysql.com/hfmain.(none)> | 2007-11-13 09:41:59 +0400 |
|---|---|---|
| committer | unknown <holyfoot/hf@mysql.com/hfmain.(none)> | 2007-11-13 09:41:59 +0400 |
| commit | d742b9cb7d6ddbaa882df365ab3c4c656fc20d95 (patch) | |
| tree | e68e3a848c63502c7b685a60f7decac836824fa1 /mysql-test | |
| parent | c6b84cec492a1f16c68ad7e2d470004f870b1182 (diff) | |
| download | mariadb-git-d742b9cb7d6ddbaa882df365ab3c4c656fc20d95.tar.gz | |
test fixed
mysql-test/r/partition_innodb.result:
result fixed
mysql-test/t/partition_innodb.test:
number of subpartitions fixed
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/partition_innodb.result | 7 | ||||
| -rw-r--r-- | mysql-test/t/partition_innodb.test | 5 |
2 files changed, 7 insertions, 5 deletions
diff --git a/mysql-test/r/partition_innodb.result b/mysql-test/r/partition_innodb.result index e007c8f3e96..f80e0001ea8 100644 --- a/mysql-test/r/partition_innodb.result +++ b/mysql-test/r/partition_innodb.result @@ -137,14 +137,15 @@ COUNT(*) 2 DROP TABLE t1; create table t1 (int_column int, char_column char(5)) -PARTITION BY RANGE (int_column) subpartition by key (char_column) +PARTITION BY RANGE (int_column) subpartition by key (char_column) subpartitions 2 (PARTITION p1 VALUES LESS THAN (5) ENGINE = InnoDB); -alter table t1 PARTITION BY RANGE (int_column) subpartition by key (char_column) +alter table t1 PARTITION BY RANGE (int_column) +subpartition by key (char_column) subpartitions 2 (PARTITION p1 VALUES LESS THAN (5) ENGINE = myisam); show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `int_column` int(11) DEFAULT NULL, `char_column` char(5) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (int_column) SUBPARTITION BY KEY (char_column) (PARTITION p1 VALUES LESS THAN (5) ENGINE = MyISAM) */ +) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (int_column) SUBPARTITION BY KEY (char_column) SUBPARTITIONS 2 (PARTITION p1 VALUES LESS THAN (5) ENGINE = MyISAM) */ drop table t1; diff --git a/mysql-test/t/partition_innodb.test b/mysql-test/t/partition_innodb.test index 0f20b34c7dc..6b73d0b2c5e 100644 --- a/mysql-test/t/partition_innodb.test +++ b/mysql-test/t/partition_innodb.test @@ -147,9 +147,10 @@ DROP TABLE t1; # Bug #31893 Partitions: crash if subpartitions and engine change # create table t1 (int_column int, char_column char(5)) - PARTITION BY RANGE (int_column) subpartition by key (char_column) + PARTITION BY RANGE (int_column) subpartition by key (char_column) subpartitions 2 (PARTITION p1 VALUES LESS THAN (5) ENGINE = InnoDB); -alter table t1 PARTITION BY RANGE (int_column) subpartition by key (char_column) +alter table t1 PARTITION BY RANGE (int_column) + subpartition by key (char_column) subpartitions 2 (PARTITION p1 VALUES LESS THAN (5) ENGINE = myisam); show create table t1; drop table t1; |