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] MySQL Verification Team
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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.