MySQL Bugs: #19067: Partitions: crash if subpartition and alter

Bug #19067	Partitions: crash if subpartition and alter
Submitted:	12 Apr 2006 23:59	Modified:	7 Jun 2006 12:08
Reporter:	Peter Gulutzan	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Partitions	Severity:	S3 (Non-critical)
Version:	5.1.10-beta-debug	OS:	Linux (SUSE 10.0)
Assigned to:	Mikael Ronström	CPU Architecture:	Any

Description:
I create a table which is partitioned by range, subpartitioned by key.
I try to alter it.
Crash.

How to repeat:
mysql> create table tg (s1 int, s2 varchar(5)) partition by range (s1) subpartition by key (s1) (partition p1 values less than (0));
Query OK, 0 rows affected (0.08 sec)

mysql> alter table tg add partition (partition p2 values less than (2));
ERROR 2013 (HY000): Lost connection to MySQL server during query

Thank you for the bug report.

060412 23:07:55 [Note] /home/miguel/dbs/5.1/libexec/mysqld: ready for connections.
Version: '5.1.10-beta-debug'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
[New Thread 1119902640 (LWP 7245)]

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 1119902640 (LWP 7245)]
0x083995a6 in partition_info::check_partition_info (this=0x9244a38, eng_type=0x0, file=0x9244650, max_rows=0)
    at partition_info.cc:712
712               if (part_elem->engine_type == NULL)
(gdb)

Patch will appear in 5.1.12

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 fix in 5.1.12 changelog. Closed.