Debian Codegraph @

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

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