Debian Codegraph @

mysql-test/suite/ndbcluster/hidden_ndb_schema.result

raw
1 # Check that mysql.ndb_schema does not show up in SHOW TABLES
2 SHOW TABLES FROM mysql LIKE 'ndb_schema';
3 Tables_in_mysql (ndb_schema)
4 # Check that mysql.ndb_schema does not show up in
5 # information_schema queries
6 SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
7 WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'ndb_schema';
8 TABLE_SCHEMA TABLE_NAME
9 # Check that table does not exist in SHOW CREATE TABLE
10 SHOW CREATE TABLE mysql.ndb_schema;
11 ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
12 #
13 # Check that table is not availble in DML queries
14 #
15 SELECT * FROM mysql.ndb_schema;
16 ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
17 INSERT INTO mysql.ndb_schema (db, name)
18 VALUES("","");
19 ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
20 REPLACE INTO mysql.ndb_schema (db, name)
21 VALUES("","");
22 ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
23 UPDATE mysql.ndb_schema SET node_id = 0
24 WHERE db="" AND name="";
25 ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
26 DELETE FROM mysql.ndb_schema
27 WHERE db="" AND name="";
28 ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
29 TRUNCATE mysql.ndb_schema;
30 ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
31 #
32 # Check that table is not availble in DDL queries
33 #
34 # It's not possible to create mysql.ndb_schema in NDB
35 # (error is slightly confusing)
36 CREATE TABLE mysql.ndb_schema(a int primary key) engine = NDB;
37 ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
38 # It's not possible to create mysql.ndb_schema in other engine
39 # (error is slightly confusing)
40 CREATE TABLE mysql.ndb_schema(a int primary key);
41 ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
42 ALTER TABLE mysql.ndb_schema ALGORITHM=copy, add column b int null;
43 ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
44 ALTER TABLE mysql.ndb_schema ALGORITHM=inplace, add column b int null;
45 ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
46 DROP TABLE mysql.ndb_schema;
47 ERROR 42S02: Table 'mysql.ndb_schema' doesn't exist
48 # Check that mysql.ndb_schema_result does not show up in
49 # information_schema queries
50 SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
51 WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'ndb_schema_result';
52 TABLE_SCHEMA TABLE_NAME
53 # No reading or modifying data
54 SELECT * FROM mysql.ndb_schema_result;
55 ERROR 42S02: Table 'mysql.ndb_schema_result' doesn't exist
56 DELETE FROM mysql.ndb_schema_result
57 WHERE nodeid=0;
58 ERROR 42S02: Table 'mysql.ndb_schema_result' doesn't exist
59 # No DDL
60 ALTER TABLE mysql.ndb_schema_result ALGORITHM=copy, add column b int null;
61 ERROR 42S02: Table 'mysql.ndb_schema_result' doesn't exist
62 DROP TABLE mysql.ndb_schema_result;
63 ERROR 42S02: Table 'mysql.ndb_schema_result' doesn't exist