From: Date: January 27 2006 4:41pm
Subject: bk commit into 5.1 tree (rburnett:1.2078) BUG#15820
List-Archive: http://lists.mysql.com/commits/1748
X-Bug: 15820
Message-Id: <200601271541.k0RFfxxw015044@production.mysql.com>

Below is the list of changes that have just been committed into a local
5.1 repository of rburnett. When rburnett does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet
  1.2078 06/01/27 16:41:53 rburnett@stripped +2 -0
  BUG#15820 - Can create table with 1 partition, then doing ALTER .. ADD PARTITION crashes
  It is ok for a partitioned table to have only 1 partition.  This test is just to show that
  doing the ALTER TABLE ADD PARTITION doesn't crash the server.
  
  partition_mgm_err.result:
    Added result block for test of bug #15820
  partition_mgm_err.test:
    Added test block for bug #15820

  mysql-test/r/partition_mgm_err.result
    1.8 06/01/27 16:39:31 rburnett@stripped +2 -0
    Added result block for test of bug #15820

  mysql-test/t/partition_mgm_err.test
    1.8 06/01/27 16:39:14 rburnett@stripped +6 -0
    Added test block for bug #15820

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	rburnett
# Host:	production.mysql.com
# Root:	/usersnfs/rburnett/mysql-5.1-bug15820

--- 1.7/mysql-test/r/partition_mgm_err.result	2006-01-26 04:46:23 +01:00
+++ 1.8/mysql-test/r/partition_mgm_err.result	2006-01-27 16:39:31 +01:00
@@ -140,3 +140,5 @@
   `a` int(11) default NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PARTITION BY KEY (a) PARTITIONS 2 
 DROP TABLE t1;
+CREATE TABLE t1 (a INT) PARTITION BY HASH(a);
+ALTER TABLE t1 ADD PARTITION PARTITIONS 4;

--- 1.7/mysql-test/t/partition_mgm_err.test	2006-01-26 04:46:24 +01:00
+++ 1.8/mysql-test/t/partition_mgm_err.test	2006-01-27 16:39:14 +01:00
@@ -210,3 +210,9 @@
 ALTER TABLE t1 PARTITION BY KEY(a) PARTITIONS 2;
 SHOW CREATE TABLE t1;
 DROP TABLE t1;
+
+#
+#BUG 15820 create table with 1 partition, doing ALTER TABLE ADD PARTITION fails
+#
+CREATE TABLE t1 (a INT) PARTITION BY HASH(a);
+ALTER TABLE t1 ADD PARTITION PARTITIONS 4;