Debian Codegraph @

mysql-test/suite/perfschema/t/dml_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 DMLs on the table
9
10 --let $table = performance_schema.binary_log_transaction_compression_stats
11
12 --disable_result_log
13 --eval SELECT * FROM $table LIMIT 1
14 --eval SELECT * FROM $table WHERE log_type='BINARY' OR COMPRESSION_TYPE='LZ4'
15 --enable_result_log
16
17 --error ER_TABLEACCESS_DENIED_ERROR
18 --eval INSERT INTO $table SET log_type='BINARY', compression_type='LZ4', transaction_counter=1, compressed_bytes_counter=2, uncompressed_bytes_counter=1, last_transaction_id="gtid", last_transaction_compressed_bytes=1, last_transaction_uncompressed_bytes=1, las_transaction_timestamp=now()
19
20 --error ER_TABLEACCESS_DENIED_ERROR
21 --eval UPDATE $table SET log_type='BINARY'
22
23 --error ER_TABLEACCESS_DENIED_ERROR
24 --eval UPDATE $table SET log_type='BINARY' WHERE compression_type="LZ4"
25
26 --error ER_TABLEACCESS_DENIED_ERROR
27 --eval DELETE FROM $table WHERE log_type='BINARY'
28
29 --error ER_TABLEACCESS_DENIED_ERROR
30 --eval DELETE FROM $table
31
32 --error ER_TABLEACCESS_DENIED_ERROR
33 --eval LOCK TABLES $table READ
34 UNLOCK TABLES;
35
36 --error ER_TABLEACCESS_DENIED_ERROR
37 --eval LOCK TABLES $table WRITE
38 UNLOCK TABLES;