1
DROP TABLE IF EXISTS t1, t2;
3
CREATE TABLE t1 (a INT)
5
(PARTITION p0 VALUES LESS THAN (6),
6
PARTITION `p1....................` VALUES LESS THAN (9),
7
PARTITION p2 VALUES LESS THAN MAXVALUE);
8
# List of files in database `test`, all original t1-files here
11
t1#P#p1@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e.MYD
12
t1#P#p1@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e.MYI
17
INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
18
# Renaming to a file name where the first partition is 250 chars
19
# and the second partition is 350 chars
20
RENAME TABLE t1 TO `t2_new..............................................end`;
21
Got one of the listed errors
22
# List of files in database `test`, should not be any t2-files here
23
# List of files in database `test`, should be all t1-files here
26
t1#P#p1@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e.MYD
27
t1#P#p1@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e.MYI
44
# List of files in database `test`, should be all t1-files here
47
t1#P#p1@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e.MYD
48
t1#P#p1@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e.MYI
53
# Renaming to a file name where the first partition is 156 chars
54
# and the second partition is 256 chars
55
RENAME TABLE t1 TO `t2_............................_end`;
56
Got one of the listed errors
57
# List of files in database `test`, should not be any t2-files here
58
# List of files in database `test`, should be all t1-files here
61
t1#P#p1@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e.MYD
62
t1#P#p1@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e.MYI
80
# Should not be any files left here
81
# End of bug#30102 test.