| Server IP : 112.74.42.100 / Your IP : 216.73.216.142 Web Server : nginx/1.20.2 System : Linux iZwz96lx4pjqiy84w4hni7Z 5.10.134-17.3.al8.x86_64 #1 SMP Thu Oct 31 14:29:57 CST 2024 x86_64 User : www ( 1000) PHP Version : 8.0.26 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 : ON | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/mysql-test/include/ |
Upload File : |
--echo ########################################################################
--echo # Verify the DD_VERSION and the CREATE TABLE statements of the
--echo # DD tables.
--echo ########################################################################
--source include/have_debug.inc
SET debug = '+d,skip_dd_table_access_check';
--echo ########################################################################
--echo # The actual DD version stored on disk.
--echo ########################################################################
let $str = `SELECT SUBSTRING_INDEX(SUBSTRING(properties,
LOCATE('DD_VERSION', properties), 30), ';', 1)
AS DD_VERSION
FROM mysql.dd_properties`;
--source include/write_line.inc
--echo ########################################################################
--echo # List the CREATE TABLE statements for the DD tables.
--echo # Mask the AUTO INCREMENT counter, which is not
--echo # deterministic when running mtr. Mask collations that
--echo # depend on the lower case table names setting.
--echo ########################################################################
replace_regex /`name` varchar\(64\) (CHARACTER SET utf8 COLLATE utf8_tolower_ci|CHARACTER SET utf8 COLLATE utf8_bin) NOT NULL/`name` varchar(64) <LCTN dependent collation> NOT NULL/
/ AUTO_INCREMENT=[0-9]+//;
let $str = `SHOW CREATE TABLE mysql.catalogs`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.character_sets`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.collations`;
--source include/write_line.inc
replace_regex /`schema_name` varchar\(64\) (CHARACTER SET utf8 COLLATE utf8_tolower_ci|CHARACTER SET utf8 COLLATE utf8_bin) NOT NULL/`schema_name` varchar(64) <LCTN dependent collation> NOT NULL/
/`table_name` varchar\(64\) (CHARACTER SET utf8 COLLATE utf8_tolower_ci|CHARACTER SET utf8 COLLATE utf8_bin) NOT NULL/`table_name` varchar(64) <LCTN dependent collation> NOT NULL/
/ AUTO_INCREMENT=[0-9]+//;
let $str = `SHOW CREATE TABLE mysql.column_statistics`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.column_type_elements`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.columns`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.dd_properties`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.events`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.foreign_key_column_usage`;
--source include/write_line.inc
replace_regex /(`referenced_table_[a-z]+` varchar\(64\)) (CHARACTER SET utf8 COLLATE utf8_tolower_ci|CHARACTER SET utf8 COLLATE utf8_bin) NOT NULL/\1 <LCTN dependent collation> NOT NULL/
/ AUTO_INCREMENT=[0-9]+//;
let $str = `SHOW CREATE TABLE mysql.foreign_keys`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.index_column_usage`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.index_partitions`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.index_stats`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.indexes`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.innodb_ddl_log`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.innodb_dynamic_metadata`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.innodb_index_stats`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.innodb_table_stats`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.parameter_type_elements`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.parameters`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.resource_groups`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.routines`;
--source include/write_line.inc
replace_regex /`name` varchar\(64\) (CHARACTER SET utf8 COLLATE utf8_tolower_ci|CHARACTER SET utf8 COLLATE utf8_bin) NOT NULL/`name` varchar(64) <LCTN dependent collation> NOT NULL/
/ AUTO_INCREMENT=[0-9]+//;
let $str = `SHOW CREATE TABLE mysql.schemata`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.st_spatial_reference_systems`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.table_partition_values`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.table_partitions`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.table_stats`;
--source include/write_line.inc
replace_regex /`name` varchar\(64\) (CHARACTER SET utf8 COLLATE utf8_tolower_ci|CHARACTER SET utf8 COLLATE utf8_bin) NOT NULL/`name` varchar(64) <LCTN dependent collation> NOT NULL/
/ AUTO_INCREMENT=[0-9]+//;
let $str = `SHOW CREATE TABLE mysql.tables`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.tablespace_files`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.tablespaces`;
--source include/write_line.inc
--replace_regex / AUTO_INCREMENT=[0-9]+//
let $str = `SHOW CREATE TABLE mysql.triggers`;
--source include/write_line.inc
replace_regex /(`routine_catalog` varchar\(64\)) (CHARACTER SET utf8 COLLATE utf8_tolower_ci|CHARACTER SET utf8 COLLATE utf8_bin) NOT NULL/\1 <LCTN dependent collation> NOT NULL/
/(`routine_schema` varchar\(64\)) (CHARACTER SET utf8 COLLATE utf8_tolower_ci|CHARACTER SET utf8 COLLATE utf8_bin) NOT NULL/\1 <LCTN dependent collation> NOT NULL/
/ AUTO_INCREMENT=[0-9]+//;
let $str = `SHOW CREATE TABLE mysql.view_routine_usage`;
--source include/write_line.inc
replace_regex /(`table_[a-z]+` varchar\(64\)) (CHARACTER SET utf8 COLLATE utf8_tolower_ci|CHARACTER SET utf8 COLLATE utf8_bin) NOT NULL/\1 <LCTN dependent collation> NOT NULL/
/ AUTO_INCREMENT=[0-9]+//;
let $str = `SHOW CREATE TABLE mysql.view_table_usage`;
--source include/write_line.inc
SET debug = '-d,skip_dd_table_access_check';