diff options
| author | unknown <reggie@linux.site> | 2006-01-23 10:39:32 -0600 |
|---|---|---|
| committer | unknown <reggie@linux.site> | 2006-01-23 10:39:32 -0600 |
| commit | 4fc47b0056e8c681c25c032701610e44ac1cb881 (patch) | |
| tree | 4b22bb7557b1a752ce52b2229c4b26f968752220 | |
| parent | fe5fde2981d06b4eb21cb660aab8da8f4276f037 (diff) | |
| download | mariadb-git-4fc47b0056e8c681c25c032701610e44ac1cb881.tar.gz | |
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
| -rw-r--r-- | mysql-test/r/partition_mgm_err.result | 13 | ||||
| -rw-r--r-- | mysql-test/t/partition_mgm_err.test | 9 |
2 files changed, 22 insertions, 0 deletions
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; diff --git a/mysql-test/t/partition_mgm_err.test b/mysql-test/t/partition_mgm_err.test index f0f29bbc2d6..4b6b4968bdb 100644 --- a/mysql-test/t/partition_mgm_err.test +++ b/mysql-test/t/partition_mgm_err.test @@ -184,3 +184,12 @@ ALTER TABLE t1 ADD PARTITION ( PARTITION p5 VALUES LESS THAN (2010), PARTITION p6 VALUES LESS THAN MAXVALUE); DROP TABLE t1; + +# +#BUG 15523 ALTER TABLE ... PARTITION BY does not work +# +CREATE TABLE t1 (a INT); +SHOW CREATE TABLE t1; +ALTER TABLE t1 PARTITION BY KEY(a) PARTITIONS 2; +SHOW CREATE TABLE t1; +DROP TABLE t1; |