| Server IP : 104.21.38.3 / Your IP : 162.158.163.172 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/parts/t/ |
Upload File : |
# Becasue of Bug 28112444 disabling this test on windows
-- source include/not_windows.inc
-- source include/have_innodb.inc
-- source include/mysql_upgrade_preparation.inc
--echo #
--echo # Bug26390736 THE FIELD TABLE_NAME (VARCHAR(64)) FROM MYSQL.INNODB_TABLE_STATS CAN OVERFLOW
--echo #
#Test 1 Table with maximum possible name
show create table mysql.innodb_index_stats;
show create table mysql.innodb_table_stats;
create table abcdefghijklmnopqrstuvwxyz_abcdefghijklmnopqrstuvwxyz_abcdefghij (id int) engine=innodb
partition by range (id)
subpartition by hash(id) (
partition pbcdefghijklmnopqrstuvwxyz_abcdefghijklmnopqrstuvwxyz_abcdefghij values less than (10) (
subpartition subdefghijklmnopqrstuvwxyz_abcdefghijklmnopqrstuvwxyz_abcdefghij,
subpartition s02
),
partition pmax VALUES LESS THAN MAXVALUE (
subpartition pmax_sub1,
subpartition pmax_sub2
)
);
--replace_regex /#P#/#p#/ /#SP#/#sp#/
select table_name,LENGTH(table_name) from mysql.innodb_table_stats where LENGTH(table_name) = 199;
--replace_regex /#P#/#p#/ /#SP#/#sp#/
select table_name,LENGTH(table_name) from mysql.innodb_index_stats where LENGTH(table_name) = 199;
drop table abcdefghijklmnopqrstuvwxyz_abcdefghijklmnopqrstuvwxyz_abcdefghij;
#Test 2 Check mysql-upgrade
#Manually change length
CALL mtr.add_suppression("Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade");
CALL mtr.add_suppression("Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade");
alter table mysql.innodb_table_stats modify table_name varchar(64);
alter table mysql.innodb_index_stats modify table_name varchar(64);
show create table mysql.innodb_index_stats;
show create table mysql.innodb_table_stats;
#Run upgrade to check if the length has changed.
--exec $MYSQL_UPGRADE --skip-verbose --force 2>&1
show create table mysql.innodb_index_stats;
show create table mysql.innodb_table_stats;
--source include/mysql_upgrade_cleanup.inc