Bug #20766 Crash when merging 2 partitions (with subpartitions) into one.
Submitted: 29 Jun 2006 8:09 Modified: 19 Jul 2006 4:11
Reporter: Horst Hunger Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Partitions Severity:S1 (Critical)
Version:5.1.12 OS:Linux (Suse 10.1)
Assigned to: Mikael Ronström CPU Architecture:Any

[29 Jun 2006 8:09] Horst Hunger 
Description:
When merging 2 partitions with subpartitions into one with subpartitions the system crashed:

ALTER TABLE tb5_eng1 REORGANIZE PARTITION part8,part9 INTO
(PARTITION part1 values in (1,2,3,4,5,6,7,8) DATA DIRECTORY =
'/data0/mysql/mysql-5.1-clone/mysql-test/var/master-data/tmpdata' INDEX DIRECTORY ='/data0/mysql/mysql-5.1-clone/mysql-test/var/master-data/tmpindex'
(SUBPARTITION subpart21, SUBPARTITION subpart22, SUBPARTITION subpart23, SUBPARTITION subpart24))

See attached program.

How to repeat:
perl mysql-test-run.pl reorg_part2_8
[29 Jun 2006 12:14] MySQL Verification Team 
Thank you for the bug report. Verified as described.
[12 Jul 2006 8:46] Mikael Ronström 
This is solved by the same patch as for bug#20893
[18 Jul 2006 8:54] Mikael Ronström 
Will appear in 5.1.12
[19 Jul 2006 4:11] Jon Stephens 
Documented bugfix in 5.1.12 changelog.