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
|
--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';
|
