1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
|
--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 utf8mb3 COLLATE utf8mb3_tolower_ci|CHARACTER SET utf8mb3 COLLATE utf8mb3_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 utf8mb3 COLLATE utf8mb3_tolower_ci|CHARACTER SET utf8mb3 COLLATE utf8mb3_bin) NOT NULL/`schema_name` varchar(64) <LCTN dependent collation> NOT NULL/
/`table_name` varchar\(64\) (CHARACTER SET utf8mb3 COLLATE utf8mb3_tolower_ci|CHARACTER SET utf8mb3 COLLATE utf8mb3_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 utf8mb3 COLLATE utf8mb3_tolower_ci|CHARACTER SET utf8mb3 COLLATE utf8mb3_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 utf8mb3 COLLATE utf8mb3_tolower_ci|CHARACTER SET utf8mb3 COLLATE utf8mb3_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 utf8mb3 COLLATE utf8mb3_tolower_ci|CHARACTER SET utf8mb3 COLLATE utf8mb3_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 utf8mb3 COLLATE utf8mb3_tolower_ci|CHARACTER SET utf8mb3 COLLATE utf8mb3_bin) NOT NULL/\1 <LCTN dependent collation> NOT NULL/
/(`routine_schema` varchar\(64\)) (CHARACTER SET utf8mb3 COLLATE utf8mb3_tolower_ci|CHARACTER SET utf8mb3 COLLATE utf8mb3_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 utf8mb3 COLLATE utf8mb3_tolower_ci|CHARACTER SET utf8mb3 COLLATE utf8mb3_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';
|
