diff options
Diffstat (limited to 'mysql-test/main/partition_rename_longfilename.test')
| -rw-r--r-- | mysql-test/main/partition_rename_longfilename.test | 51 |
1 files changed, 51 insertions, 0 deletions
diff --git a/mysql-test/main/partition_rename_longfilename.test b/mysql-test/main/partition_rename_longfilename.test new file mode 100644 index 00000000000..51d9c583f56 --- /dev/null +++ b/mysql-test/main/partition_rename_longfilename.test @@ -0,0 +1,51 @@ +-- source include/not_windows.inc +-- source include/support_long_file_names.inc +-- source include/have_partition.inc +-- source include/not_embedded.inc +--disable_warnings +DROP TABLE IF EXISTS t1, t2; +--enable_warnings +let $MYSQLD_DATADIR= `SELECT @@datadir`; + +# +# Bug#30102: rename table does corrupt tables with partition files on failure +# This test case renames the table such that the partition file name +# is 255 chars long. Due the restriction of 260 char path name (including drive label) +# this will fail in windows. +# Other tests related to this bug can be found in partition_not_embedded.test +# +CREATE TABLE t1 (a INT) +PARTITION BY RANGE (a) +(PARTITION p0 VALUES LESS THAN (6), + PARTITION `p1....................` VALUES LESS THAN (9), + PARTITION p2 VALUES LESS THAN MAXVALUE); +# partition p1 is 't1#P#p1' + @002e * 20 = 107 characters + file ending +# total path lenght of './test/t1#P#p1@002e@002e<...>@002e.MY[ID]' is 118 chars +--echo # List of files in database `test`, all original t1-files here +--list_files $MYSQLD_DATADIR/test t1* +INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10); +--echo # Renaming to a file name where the first partition is 155 chars +--echo # and the second partition is 255 chars +RENAME TABLE t1 TO `t2_............................end`; +# 1234567890123456789012345678 +# t2_ + end +# .MY[ID] or .frm +# #P#p[012] +# 28 * @002e +# 6 + 4 + 5 + 28 * 5 = 155 +--echo # List of files in database `test`, should not be any t1-files here +--list_files $MYSQLD_DATADIR/test t1* +--echo # List of files in database `test`, should be all t2-files here +--list_files $MYSQLD_DATADIR/test t2* +--sorted_result +SELECT * FROM `t2_............................end`; +RENAME TABLE `t2_............................end` to t1; +--echo # List of files in database `test`, should be all t1-files here +--list_files $MYSQLD_DATADIR/test t1* +--sorted_result +SELECT * FROM t1; +DROP TABLE t1; +--echo # Should not be any files left here +--list_files $MYSQLD_DATADIR/test t1* +--list_files $MYSQLD_DATADIR/test t2* +--echo # End of bug#30102 test. |