Bug #20756 Move of a partition with subpartitions by REORGANIZE cause a crash.
Submitted: 28 Jun 2006 16:33 Modified: 3 Aug 2006 13:15
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: CPU Architecture:Any

[28 Jun 2006 16:33] Horst Hunger
Description:
The following ALTER statement caused a crash:

ALTER TABLE systest1.tb5_eng1 REORGANIZE PARTITION part1 INTO
 (PARTITION part7 values in (1,2,3,4) $data_directory $index_directory 
(SUBPARTITION subpart71, SUBPARTITION subpart72));

How to repeat:
Not decided. See comments.
[4 Jul 2006 15:11] Horst Hunger
I was not able to reproduce the bug with a small program. May be, that somebody with the knowledge of the source code (see backtrace) is able to reproduce it with a small test program or the backtrace by itself is sufficent for futher analysis.
[12 Jul 2006 8:32] Mikael Ronström
This is most likely a duplicate of bug 20893
which made many REORGANIZE commands crash or misbehave
There is a approved patch available for this bug
[14 Jul 2006 8:00] Valeriy Kravchuk
As there is no simple test case for thiese, please, check with a version that will contain fix for bug #20893 (when it will be closed), and inform about the results. Then we'll be able to decide is this a duplicate or a separate bug.
[3 Aug 2006 13:15] Valeriy Kravchuk
So, this bug seems fixed with the same patch as bug #20893.