polardbxengine/mysql-test/suite/xengine_perfschema/t/ddl_tiws_by_table.test

18 lines
600 B
Plaintext

# Tests for PERFORMANCE_SCHEMA
-- error ER_DBACCESS_DENIED_ERROR
alter table performance_schema.table_io_waits_summary_by_table
add column foo integer;
truncate table performance_schema.table_io_waits_summary_by_table;
-- error ER_DBACCESS_DENIED_ERROR
ALTER TABLE performance_schema.table_io_waits_summary_by_table ADD INDEX test_index(TABLE_NAME);
-- error ER_DBACCESS_DENIED_ERROR
CREATE UNIQUE INDEX test_index ON performance_schema.table_io_waits_summary_by_table(TABLE_NAME);
-- error ER_DBACCESS_DENIED_ERROR
DROP INDEX `OBJECT`
ON performance_schema.table_io_waits_summary_by_table;