Debian Codegraph @

mysql-test/suite/ndb/t/ndb_pfs_tables.test

raw
1 --source include/have_ndb.inc
2
3 #
4 # Basic test for Performance Schema tables added by the ndbcluster plugin
5 # - Check table definitions
6 # - Check if tables are readable/writable as per design
7 #
8
9 SHOW TABLES IN performance_schema LIKE 'ndb%';
10 SHOW CREATE TABLE performance_schema.ndb_sync_pending_objects;
11 SHOW CREATE TABLE performance_schema.ndb_sync_excluded_objects;
12 SELECT * FROM performance_schema.ndb_sync_pending_objects;
13 SELECT * FROM performance_schema.ndb_sync_excluded_objects;
14 --error ER_TABLEACCESS_DENIED_ERROR
15 INSERT INTO performance_schema.ndb_sync_pending_objects VALUES('test','t1','TABLE');
16 --error ER_TABLEACCESS_DENIED_ERROR
17 INSERT INTO performance_schema.ndb_sync_excluded_objects VALUES('test','t1','TABLE','Excluded');