| Server IP : 185.86.78.101 / Your IP : 216.73.216.124 Web Server : Apache System : Linux 675867-vds-valikoshka1996.gmhost.pp.ua 5.4.0-150-generic #167-Ubuntu SMP Mon May 15 17:35:05 UTC 2023 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /www/server/mysql/mysql-test/t/ |
Upload File : |
-- source include/not_windows.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.