From 4fc47b0056e8c681c25c032701610e44ac1cb881 Mon Sep 17 00:00:00 2001 From: unknown Date: Mon, 23 Jan 2006 10:39:32 -0600 Subject: BUG# 15523 - ALTER TABLE ... PARTITION BY does not work this was fixed by WL 2604 mysql-test/r/partition_mgm_err.result: result block for bug#15523 mysql-test/t/partition_mgm_err.test: test block for bug #15523 --- mysql-test/r/partition_mgm_err.result | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'mysql-test/r/partition_mgm_err.result') diff --git a/mysql-test/r/partition_mgm_err.result b/mysql-test/r/partition_mgm_err.result index e9086ddcc20..38a69e93536 100644 --- a/mysql-test/r/partition_mgm_err.result +++ b/mysql-test/r/partition_mgm_err.result @@ -125,3 +125,16 @@ ALTER TABLE t1 ADD PARTITION ( PARTITION p5 VALUES LESS THAN (2010), PARTITION p6 VALUES LESS THAN MAXVALUE); DROP TABLE t1; +CREATE TABLE t1 (a INT); +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) default NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +ALTER TABLE t1 PARTITION BY KEY(a) PARTITIONS 2; +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) default NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 PARTITION BY KEY (a) PARTITIONS 2 +DROP TABLE t1; -- cgit v1.2.1