Debian Codegraph @

mysql-test/suite/perfschema/t/ddl_accounts.test

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 -- error ER_DBACCESS_DENIED_ERROR
4 alter table performance_schema.accounts
5 add column foo integer;
6
7 truncate table performance_schema.accounts;
8
9 -- error ER_DBACCESS_DENIED_ERROR
10 ALTER TABLE performance_schema.accounts ADD INDEX test_index(CURRENT_CONNECTIONS);
11
12 -- error ER_DBACCESS_DENIED_ERROR
13 CREATE UNIQUE INDEX test_index ON performance_schema.accounts(CURRENT_CONNECTIONS);
14
15 -- error ER_DBACCESS_DENIED_ERROR
16 DROP INDEX `PRIMARY` ON performance_schema.accounts;
17
18 -- error ER_DBACCESS_DENIED_ERROR
19 DROP INDEX `ACCOUNT`
20 ON performance_schema.accounts;
21
22 CREATE TABLE test.create_select
23 AS SELECT * from performance_schema.accounts;
24
25 DROP TABLE test.create_select;