1DROP TABLE IF EXISTS t1, t2; 2CREATE TABLE t1 (a INT) 3PARTITION BY RANGE (a) 4(PARTITION p0 VALUES LESS THAN (6), 5PARTITION `p1....................` VALUES LESS THAN (9), 6PARTITION p2 VALUES LESS THAN MAXVALUE); 7# List of files in database `test`, all original t1-files here 8t1#P#p0.MYD 9t1#P#p0.MYI 10t1#P#p1@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e.MYD 11t1#P#p1@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e.MYI 12t1#P#p2.MYD 13t1#P#p2.MYI 14t1.frm 15t1.par 16INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10); 17# Renaming to a file name where the first partition is 155 chars 18# and the second partition is 255 chars 19RENAME TABLE t1 TO `t2_............................end`; 20# List of files in database `test`, should not be any t1-files here 21# List of files in database `test`, should be all t2-files here 22t2_@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend#P#p0.MYD 23t2_@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend#P#p0.MYI 24t2_@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend#P#p1@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e.MYD 25t2_@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend#P#p1@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e.MYI 26t2_@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend#P#p2.MYD 27t2_@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend#P#p2.MYI 28t2_@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend.frm 29t2_@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend.par 30SELECT * FROM `t2_............................end`; 31a 321 3310 342 353 364 375 386 397 408 419 42RENAME TABLE `t2_............................end` to t1; 43# List of files in database `test`, should be all t1-files here 44t1#P#p0.MYD 45t1#P#p0.MYI 46t1#P#p1@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e.MYD 47t1#P#p1@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e.MYI 48t1#P#p2.MYD 49t1#P#p2.MYI 50t1.frm 51t1.par 52SELECT * FROM t1; 53a 541 5510 562 573 584 595 606 617 628 639 64DROP TABLE t1; 65# Should not be any files left here 66# End of bug#30102 test. 67