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.