Bug #20717 Reorganize partition ignores directory part.
Submitted: 27 Jun 2006 9:31 Modified: 27 Jun 2006 15:56
Reporter: Horst Hunger Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Partitions Severity:S2 (Serious)
Version:5.1.12 OS:Linux (Suse 10.1)
Assigned to: CPU Architecture:Any

[27 Jun 2006 9:31] Horst Hunger
Description:
Instead of putting the partiton into the directories defined by the user, they are put into the default directory (see also bug#20355).
Example:

ALTER TABLE systest1.tb2_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',
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');

How to repeat:
Create  a table as follows:

create table tb2_eng1 (
f1 int,
f2 char (15),
f3 decimal (5,3),
f4 datetime, index (f1)
) engine=myisam
PARTITION BY LIST (f1)
(PARTITION part1 VALUES in(1,2,3,4) 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,
PARTITION part2 VALUES in (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,
PARTITION part3 VALUES in (9,10,11,12) 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,
PARTITION part4 VALUES in (13,14,15)  INDEX DIRECTORY = '/data0/mysql/mysql-5.1-clone/mysql-test/var/master-data/tmpindex
);

Execute the Alter statement above.
[27 Jun 2006 13:24] Valeriy Kravchuk
Thank you for a problem report. Looks like a duplicate of a verified bug #20355 for me. Is there any difference/new behaviour you demonstrated here?
[27 Jun 2006 14:27] Horst Hunger
No.
[27 Jun 2006 15:56] Valeriy Kravchuk
Duplicate of bug #20355.