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