Bug #20770 Partitions not removed after reorganize.
Submitted: 29 Jun 2006 10:34 Modified: 19 Jul 2006 4:26
Reporter: Horst Hunger Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Partitions Severity:S3 (Non-critical)
Version:5.1.12 OS:Linux (Suse 10.1)
Assigned to: Mikael Ronström CPU Architecture:Any

[29 Jun 2006 10:34] Horst Hunger
Description:
The files 

tb5_eng1#P#part9#SP#subpart92.MYD
tb5_eng1#P#part9#SP#subpart92.MYI

still exist after the following ALTER...REORGANIZE statements:

ALTER TABLE tb5_eng1 REORGANIZE PARTITION part2 INTO
 (PARTITION part8 values in (5,6) $data_directory $index_directory (SUBPARTITION subpart81, SUBPARTITION subpart82),
  PARTITION part9 values in (7,8) $data_directory $index_directory (SUBPARTITION subpart91, SUBPARTITION subpart92));

ALTER TABLE tb5_eng1 REORGANIZE PARTITION part8,part9 INTO
 (PARTITION part2 values in (5,6,7,8) $data_directory $index_directory 
(SUBPARTITION subpart21, SUBPARTITION subpart22));

See program attached.

How to repeat:
perl mysql-test-run.pl error_reorg_part2_8_92
[29 Jun 2006 10:36] Horst Hunger
program to reproduce the bug

Attachment: error_reorg_part2_8_92.test (application/octet-stream, text), 1.81 KiB.

[29 Jun 2006 12:03] Miguel Solorzano
Thank you for the bug report. Verified as described:
miguel@hegel:~/dbs/mysql-5.1/mysql-test/var/master-data/test> ls tb5_eng1#P#part9#SP#subpart92*
tb5_eng1#P#part9#SP#subpart92.MYD  tb5_eng1#P#part9#SP#subpart92.MYI
[5 Jul 2006 11:30] Mikael Ronström
Needed to call set_up_table_before_create also when altering partitions
Also found an error in default handling of options for subpartitions while at it
[18 Jul 2006 8:56] Mikael Ronström
Will appear in 5.1.12
[19 Jul 2006 4:26] Jon Stephens
Documented bugfix in 5.1.12 changelog.