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
|
# Check that mysql.ndb_schema does not show up in SHOW TABLES
SHOW TABLES FROM mysql LIKE 'ndb_schema';
Tables_in_mysql (ndb_schema)
# Check that mysql.ndb_schema does not show up in
# information_schema queries
SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'ndb_schema';
TABLE_SCHEMA TABLE_NAME
# Check that table does not exist in SHOW CREATE TABLE
SHOW CREATE TABLE mysql.ndb_schema;
ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
#
# Check that table is not availble in DML queries
#
SELECT * FROM mysql.ndb_schema;
ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
INSERT INTO mysql.ndb_schema (db, name)
VALUES("","");
ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
REPLACE INTO mysql.ndb_schema (db, name)
VALUES("","");
ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
UPDATE mysql.ndb_schema SET node_id = 0
WHERE db="" AND name="";
ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
DELETE FROM mysql.ndb_schema
WHERE db="" AND name="";
ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
TRUNCATE mysql.ndb_schema;
ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
#
# Check that table is not availble in DDL queries
#
# It's not possible to create mysql.ndb_schema in NDB
# (error is slightly confusing)
CREATE TABLE mysql.ndb_schema(a int primary key) engine = NDB;
ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
# It's not possible to create mysql.ndb_schema in other engine
# (error is slightly confusing)
CREATE TABLE mysql.ndb_schema(a int primary key);
ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
ALTER TABLE mysql.ndb_schema ALGORITHM=copy, add column b int null;
ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
ALTER TABLE mysql.ndb_schema ALGORITHM=inplace, add column b int null;
ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
DROP TABLE mysql.ndb_schema;
ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
# Check that mysql.ndb_schema_result does not show up in
# information_schema queries
SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'ndb_schema_result';
TABLE_SCHEMA TABLE_NAME
# No reading or modifying data
SELECT * FROM mysql.ndb_schema_result;
ERROR 42S02: Table 'mysql.ndb_schema_result' doesn't exist
DELETE FROM mysql.ndb_schema_result
WHERE nodeid=0;
ERROR 42S02: Table 'mysql.ndb_schema_result' doesn't exist
# No DDL
ALTER TABLE mysql.ndb_schema_result ALGORITHM=copy, add column b int null;
ERROR 42S02: Table 'mysql.ndb_schema_result' doesn't exist
DROP TABLE mysql.ndb_schema_result;
ERROR 42S02: Table 'mysql.ndb_schema_result' doesn't exist
|
