| 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 hard coded ids of the mysql schema, the mysql tablespace,
--echo # the dd_properties table, and the innodb_dynamic_metadata table.
--echo ########################################################################
--source include/have_debug.inc
SET debug = '+d,skip_dd_table_access_check';
--echo ########################################################################
--echo # The id of the mysql schema must be fixed.
--echo ########################################################################
let $assert_cond = "[SELECT id FROM mysql.schemata WHERE name LIKE \'mysql\']"
= 1;
--let $assert_text = The id of the 'mysql' schema is 1.
--source include/assert.inc
--echo ########################################################################
--echo # The ids of the mysql tablespace must be fixed.
--echo ########################################################################
let $assert_cond = "[SELECT id FROM mysql.tablespaces WHERE name LIKE
\'mysql\']"
= 1;
--let $assert_text = The id of the 'mysql' tablespace is 1.
--source include/assert.inc
let $assert_cond = "[SELECT SUBSTRING_INDEX(SUBSTRING(se_private_data,
LOCATE(\'id\', se_private_data), 30), \';\', 1)
FROM mysql.tablespaces WHERE name LIKE \'mysql\']"
= "id=4294967294";
--let $assert_text = The SE private id of the 'mysql' tablespace is 4294967294.
--source include/assert.inc
--echo ########################################################################
--echo # The ids of the dd_properties table must be fixed.
--echo ########################################################################
let $assert_cond = "[SELECT id FROM mysql.tables
WHERE name LIKE \'dd_properties\' AND schema_id = 1]"
= 1;
--let $assert_text = The id of 'mysql.dd_properties' is 1.
--source include/assert.inc
let $assert_cond = "[SELECT se_private_id FROM mysql.tables
WHERE name LIKE \'dd_properties\' AND schema_id = 1]"
= 1;
--let $assert_text = The SE private id of 'mysql.dd_properties' is 1.
--source include/assert.inc
let $assert_cond = "[SELECT id FROM mysql.indexes
WHERE table_id =
(SELECT id FROM mysql.tables
WHERE name LIKE \'dd_properties\'
AND schema_id = 1)]"
= 1;
--let $assert_text = The clustering index id of 'mysql.dd_properties' is 1.
--source include/assert.inc
--echo ########################################################################
--echo # The ids of the innodb_dynamic_metadata table must be fixed.
--echo ########################################################################
let $assert_cond = "[SELECT id FROM mysql.tables
WHERE name LIKE \'innodb_dynamic_metadata\'
AND schema_id = 1]"
= 2;
--let $assert_text = The id of 'mysql.innodb_dynamic_metadata' is 2.
--source include/assert.inc
let $assert_cond = "[SELECT se_private_id FROM mysql.tables
WHERE name LIKE \'innodb_dynamic_metadata\'
AND schema_id = 1]"
= 2;
--let $assert_text = The SE private id of 'mysql.innodb_dynamic_metadata' is 2.
--source include/assert.inc
let $assert_cond = "[SELECT id FROM mysql.indexes
WHERE table_id =
(SELECT id FROM mysql.tables
WHERE name LIKE \'innodb_dynamic_metadata\'
AND schema_id = 1)]"
= 2;
--let $assert_text = The index id of 'mysql.innodb_dynamic_metadata' is 2.
--source include/assert.inc
SET debug = '-d,skip_dd_table_access_check';