Bug #20767 Crash due to split of one partition with subpartitions ino 2.
Submitted: 29 Jun 2006 8:32 Modified: 19 Jul 2006 4:14
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:32] Horst Hunger
Description:
The following ALTER statement 

ALTER TABLE tb5_eng1 REORGANIZE PARTITION part2 INTO
(PARTITION part8 values in (5,6) 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 subpart81, SUBPARTITION subpart82,SUBPARTITION subpart83, SUBPARTITION subpart84),
PARTITION part9 values in (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 subpart91, SUBPARTITION subpart92,SUBPARTITION subpart93, SUBPARTITION subpart94)

contains a split of one partition with 4 values (4 subpartitions) into 2 partitions with each 2 values and  4 subpartitions. I assume that this should be rejected.

See attached program.

How to repeat:
perl mysql-test-run.pl error_reorg_part2_8
[29 Jun 2006 12:10] MySQL Verification Team
Thank you for the bug report. Verified as described:

'/home/miguel/dbs/mysql-5.1/mysql-test/var/master-data/tmpindex' (SUBPARTITION subpart91, SUBPARTITION subpart92,SUBPARTITION subpart93, SUBPARTITION subpart94))' failed: 2013: Lost connection to MySQL server during query
[12 Jul 2006 8:47] Mikael Ronström
This is solved by the same patch as bug#20893
[18 Jul 2006 8:55] Mikael Ronström
Will appear in 5.1.12
[19 Jul 2006 4:14] Jon Stephens
Documented bugfix in 5.1.12 changelog.