Bug #17140 Partitions: crash if add partition if subpartitions
Submitted: 5 Feb 2006 18:42 Modified: 16 Mar 2006 8:24
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Partitions Severity:S3 (Non-critical)
Version:5.1.7-beta-debug OS:Linux (SUSE 10.0)
Assigned to: Mikael Ronström CPU Architecture:Any

[5 Feb 2006 18:42] Peter Gulutzan
Description:
I create a table with partitions and subpartitions.
I say "alter table ... add partition ...".
Crash.

How to repeat:
mysql> create table txr (s1 int, s2 int) partition by list (s1) partitions 1 subpartition by hash (s2) (partition p1 values in (1));
Query OK, 0 rows affected (0.01 sec)

mysql> alter table txr add partition (partition p2 values in (2));
ERROR 2013 (HY000): Lost connection to MySQL server during query
[6 Feb 2006 0:52] Miguel Solorzano
Thank you for the bug report.

mysql> alter table txr add partition (partition p2 values in (2));
ERROR 2013 (HY000): Lost connection to MySQL server during query
[13 Mar 2006 10:43] Mikael Ronström
this bug is fixed by the same patch as bug #17127
[14 Mar 2006 17:46] Mikael Ronström
A crash occurred when conflicting values statement was used in the alter table
statement for partitioning
[16 Mar 2006 8:24] Jon Stephens
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Documented bugfix in 5.1.8 changelog. Closed.