135 lines
6.9 KiB
PHP
135 lines
6.9 KiB
PHP
--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';
|