Server IP : 172.67.216.182 / Your IP : 162.158.162.73 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 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 : ON Directory : /www/server/mysql/src/mysql-test/suite/innodb/include/ |
Upload File : |
# Remember some variables. LET $MYSQLD_DATADIR = `select @@datadir`; LET $INNODB_PAGE_SIZE = `select @@innodb_page_size`; --echo # --echo # Try a series of invalid relative ADD DATAFILE entries. --echo # General tablespace files can be in the datadir but they cannot be under the datadir. --echo # --error ER_WRONG_FILE_NAME CREATE TABLESPACE bad ADD DATAFILE ''; SHOW WARNINGS; --error ER_WRONG_FILE_NAME CREATE TABLESPACE bad ADD DATAFILE '.ibd'; SHOW WARNINGS; --error ER_WRONG_FILE_NAME CREATE TABLESPACE bad ADD DATAFILE './ibd'; SHOW WARNINGS; --error ER_WRONG_FILE_NAME CREATE TABLESPACE bad ADD DATAFILE './.ibd'; SHOW WARNINGS; --error ER_WRONG_FILE_NAME CREATE TABLESPACE bad ADD DATAFILE '../spaces/'; SHOW WARNINGS; --error ER_WRONG_FILE_NAME CREATE TABLESPACE bad ADD DATAFILE 'test/bad.ibd'; SHOW WARNINGS; --error ER_WRONG_FILE_NAME CREATE TABLESPACE bad ADD DATAFILE './test/bad.ibd'; SHOW WARNINGS; --error ER_WRONG_FILE_NAME CREATE TABLESPACE bad ADD DATAFILE './test//bad.ibd'; SHOW WARNINGS; --error ER_WRONG_FILE_NAME CREATE TABLESPACE bad ADD DATAFILE '../data/test/bad.ibd'; SHOW WARNINGS; --error ER_WRONG_FILE_NAME CREATE TABLESPACE bad ADD DATAFILE '../data/../data/test/bad.ibd'; SHOW WARNINGS; --error ER_WRONG_FILE_NAME CREATE TABLESPACE bad ADD DATAFILE '../does_not_exist/bad.ibd'; SHOW WARNINGS; --echo # --echo # Try a series of valid relative ADD DATAFILE entries. --echo # General tablespace files can be in the datadir but they cannot be under the datadir. --echo # CREATE TABLESPACE ibport_s01 ADD DATAFILE 'ibport_s01.ibd'; CREATE TABLESPACE ibport_s02 ADD DATAFILE './ibport_s02.ibd'; CREATE TABLESPACE ibport_s03 ADD DATAFILE '../data/ibport_s03.ibd'; CREATE TABLESPACE ibport_s04 ADD DATAFILE 'test/../ibport_s04.ibd'; CREATE TABLESPACE ibport_s05 ADD DATAFILE './test/../ibport_s05.ibd'; CREATE TABLESPACE ibport_s06 ADD DATAFILE '..///data//test///..//ibport_s06.ibd'; CREATE TABLESPACE ibport_s12 ADD DATAFILE '.\\ibport_s12.ibd'; CREATE TABLESPACE ibport_s13 ADD DATAFILE '..\\data\\ibport_s13.ibd'; CREATE TABLESPACE ibport_s14 ADD DATAFILE 'test\\..\\ibport_s14.ibd'; CREATE TABLESPACE ibport_s15 ADD DATAFILE '.\\test\\..\\ibport_s15.ibd'; CREATE TABLESPACE ibport_s16 ADD DATAFILE '..\\\\\\data\\\\test\\\\\\..\\\\ibport_s16.ibd'; --echo # Directory listing of MYSQLD_DATADIR/ ibport* --list_files $MYSQLD_DATADIR/ ibport* --replace_result $MYSQLD_DATADIR/ MYSQLD_DATADIR/ $MYSQLD_DATADIR MYSQLD_DATADIR/ SELECT s.space_type 'Type', s.name 'Space Name', d.path 'Path' FROM information_schema.innodb_sys_tablespaces s, information_schema.innodb_sys_datafiles d WHERE s.name like '%ibport%' AND s.space = d.space ORDER BY s.space; --replace_result $MYSQLD_DATADIR/ MYSQLD_DATADIR/ $MYSQLD_DATADIR MYSQLD_DATADIR/ SELECT s.space_type 'Type', s.name 'Space Name', f.file_name 'Path' FROM information_schema.innodb_sys_tablespaces s, information_schema.files f WHERE s.name like '%ibport%' AND s.space = f.file_id ORDER BY s.space; DROP TABLESPACE ibport_s01; DROP TABLESPACE ibport_s02; DROP TABLESPACE ibport_s03; DROP TABLESPACE ibport_s04; DROP TABLESPACE ibport_s05; DROP TABLESPACE ibport_s06; DROP TABLESPACE ibport_s12; DROP TABLESPACE ibport_s13; DROP TABLESPACE ibport_s14; DROP TABLESPACE ibport_s15; DROP TABLESPACE ibport_s16;