Bug #32569 COALESCE PARTITION crashes server when reducing LINEAR HASH table to 1 partition
Submitted: 21 Nov 2007 12:32 Modified: 27 Nov 2007 10:12
Reporter: Philip Stoev Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Partitions Severity:S3 (Non-critical)
Version:mysql-5.1.22-rc OS:Any
Assigned to: CPU Architecture:Any

[21 Nov 2007 12:32] Philip Stoev 
Description:
MySQL will crash if COALESCE PARTITION is issued on a LINEAR HASH partitioned table when the number of partitions is reduced to 1.

How to repeat:
CREATE TABLE t1 (id INT NOT NULL)
PARTITION BY LINEAR HASH(id)
PARTITIONS 2;
INSERT INTO t1 VALUES (1);
ALTER TABLE t1 COALESCE PARTITION 1;

Table must contain rows for the crash to occur. If partitions after coalesce are more than 1, no crash occurs. Simple HASH partitioning (without LINEAR) does not crash. Engine is MyISAM.
[21 Nov 2007 13:51] Philip Stoev 
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 bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html
[27 Nov 2007 10:12] Mattias Jonsson 
This is a duplicate of Bug#30822