Debian Codegraph @

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

raw
1 # ==== Purpose ====
2 #
3 # Tests for PERFORMANCE_SCHEMA
4 #
5 # This test verifies the correct behaviour in case of invalid
6 # usage of DDLs on the table log_status
7 #
8 # ==== References ====
9 #
10 # WL#9452: Log Position Lock
11 #
12
13 -- error ER_DBACCESS_DENIED_ERROR
14 ALTER TABLE performance_schema.log_status
15 ADD COLUMN foo integer;
16
17 -- error ER_TABLEACCESS_DENIED_ERROR
18 TRUNCATE TABLE performance_schema.log_status;
19
20 -- error ER_DBACCESS_DENIED_ERROR
21 ALTER TABLE performance_schema.log_status
22 ADD INDEX test_index(server_uuid);
23
24 -- error ER_DBACCESS_DENIED_ERROR
25 CREATE UNIQUE INDEX test_index ON
26 performance_schema.log_status(server_uuid);
27
28 CREATE TABLE test.create_select
29 AS SELECT * from performance_schema.log_status;
30
31 DROP TABLE test.create_select;