Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 #
4 # WL#3549
5 #
6
7 # This test verifies the correct behaviour in case of invalid
8 # usage of DDLs on the table performance_schema.binary_log_transaction_compression_stats
9
10 --let $table = performance_schema.binary_log_transaction_compression_stats
11
12 --error ER_DBACCESS_DENIED_ERROR
13 --eval ALTER TABLE $table add column foo integer;
14
15 --eval TRUNCATE TABLE $table
16
17 --error ER_DBACCESS_DENIED_ERROR
18 --eval ALTER TABLE $table ADD INDEX test_index(last_transaction_id);
19
20 --error ER_DBACCESS_DENIED_ERROR
21 --eval CREATE UNIQUE INDEX test_index ON $table(last_transaction_id);
22
23 --error ER_DBACCESS_DENIED_ERROR
24 --eval DROP INDEX `PRIMARY` ON $table
25
26 --eval CREATE TABLE test.create_select AS SELECT * from $table;
27
28 DROP TABLE test.create_select;