Server IP : 104.21.38.3 / Your IP : 172.69.176.123 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/funcs_1/datadict/ |
Upload File : |
# suite/funcs_1/datadict/tables2.inc # # Auxiliary script to be sourced by suite/funcs_1/datadict/tables1.inc. # # Author: # 2008-01-23 mleich WL#4203 Reorganize and fix the data dictionary tests of # testsuite funcs_1 # Create this script based on older scripts and new code. # ################################################################################ # 8 TABLE_ROWS # 9 AVG_ROW_LENGTH # 10 DATA_LENGTH # 11 MAX_DATA_LENGTH # 12 INDEX_LENGTH # 13 DATA_FREE # 15 CREATE_TIME # 16 UPDATE_TIME # 17 CHECK_TIME # 20 CREATE_OPTIONS # 21 TABLE_COMMENT User defined comment # + InnoDB # + NDB: "number_of_replicas: <number>" appended # + InnoDB: "InnoDB free: <number_kB> kB" appended # <number_kB> depends on tablespace history! # The LEFT/INSTR/IF/LENGTH stuff should remove these # storage engine specific part. let $innodb_pattern = 'InnoDB free'; let $ndb_pattern = 'number_of_replicas'; --vertical_results # We do not unify the engine name here, because the rowformat is # specific to the engine. --replace_column 8 "#TBLR#" 9 "#ARL#" 10 "#DL#" 11 "#MDL#" 12 "#IL#" 13 "#DF#" 15 "#CRT#" 16 "#UT#" 17 "#CT#" 20 "#CO#" 21 "#TC#" --replace_result InnoDB TMP_TABLE_ENGINE MyISAM TMP_TABLE_ENGINE eval SELECT *, LEFT( table_comment, IF(INSTR(table_comment,$innodb_pattern) = 0 AND INSTR(table_comment,$ndb_pattern) = 0, LENGTH(table_comment), INSTR(table_comment,$innodb_pattern) + INSTR(table_comment,$ndb_pattern) - 1)) AS "user_comment", '-----------------------------------------------------' AS "Separator" FROM information_schema.tables $my_where ORDER BY table_schema,table_name; --horizontal_results