1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
# Tests for PERFORMANCE_SCHEMA
--source include/not_embedded.inc
--source include/have_perfschema.inc
-- error ER_DBACCESS_DENIED_ERROR
alter table performance_schema.table_lock_waits_summary_by_table
add column foo integer;
truncate table performance_schema.table_lock_waits_summary_by_table;
-- error ER_DBACCESS_DENIED_ERROR
ALTER TABLE performance_schema.table_lock_waits_summary_by_table ADD INDEX test_index(TABLE_NAME);
-- error ER_DBACCESS_DENIED_ERROR
CREATE UNIQUE INDEX test_index ON performance_schema.table_lock_waits_summary_by_table(TABLE_NAME);
|
