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
|
#
# The ndbcluster plugin creates a table in NDB which is used for
# communicating between the MySQL Servers connected to the same cluster
# while doing schema changes.
#
# The table is called ndb_schema and is in the mysql database.
#
# The table is hidden. It should not show up in information_schema
# queries nor SHOW tables. Starting from MySQL Server 8.0 such a hidden
# table is also not available in neither DML nor DML queries
#
--source include/have_ndb.inc
--echo # Check that mysql.ndb_schema does not show up in SHOW TABLES
SHOW TABLES FROM mysql LIKE 'ndb_schema';
--echo # Check that mysql.ndb_schema does not show up in
--echo # information_schema queries
SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'ndb_schema';
--echo # Check that table does not exist in SHOW CREATE TABLE
--error ER_NO_SUCH_TABLE
SHOW CREATE TABLE mysql.ndb_schema;
--echo #
--echo # Check that table is not availble in DML queries
--echo #
--error ER_NO_SUCH_TABLE
SELECT * FROM mysql.ndb_schema;
--error ER_NO_SUCH_TABLE
INSERT INTO mysql.ndb_schema (db, name)
VALUES("","");
--error ER_NO_SUCH_TABLE
REPLACE INTO mysql.ndb_schema (db, name)
VALUES("","");
--error ER_NO_SUCH_TABLE
UPDATE mysql.ndb_schema SET node_id = 0
WHERE db="" AND name="";
--error ER_NO_SUCH_TABLE
DELETE FROM mysql.ndb_schema
WHERE db="" AND name="";
--error ER_NO_SUCH_TABLE
TRUNCATE mysql.ndb_schema;
--echo #
--echo # Check that table is not availble in DDL queries
--echo #
--echo # It's not possible to create mysql.ndb_schema in NDB
--echo # (error is slightly confusing)
--error ER_NO_SUCH_TABLE
CREATE TABLE mysql.ndb_schema(a int primary key) engine = NDB;
--echo # It's not possible to create mysql.ndb_schema in other engine
--echo # (error is slightly confusing)
--error ER_NO_SUCH_TABLE
CREATE TABLE mysql.ndb_schema(a int primary key);
--error ER_NO_SUCH_TABLE
ALTER TABLE mysql.ndb_schema ALGORITHM=copy, add column b int null;
--error ER_NO_SUCH_TABLE
ALTER TABLE mysql.ndb_schema ALGORITHM=inplace, add column b int null;
--error ER_NO_SUCH_TABLE
DROP TABLE mysql.ndb_schema;
#
# WL#10162 adds another schema distribution table called ndb_schema_result. It
# should be hidden in the same way as ndb_schema. Run some selected checks to
# verify that ndb_schema_result is also hidden.
#
--echo # Check that mysql.ndb_schema_result does not show up in
--echo # information_schema queries
SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'ndb_schema_result';
--echo # No reading or modifying data
--error ER_NO_SUCH_TABLE
SELECT * FROM mysql.ndb_schema_result;
--error ER_NO_SUCH_TABLE
DELETE FROM mysql.ndb_schema_result
WHERE nodeid=0;
--echo # No DDL
--error ER_NO_SUCH_TABLE
ALTER TABLE mysql.ndb_schema_result ALGORITHM=copy, add column b int null;
--error ER_NO_SUCH_TABLE
DROP TABLE mysql.ndb_schema_result;
|
