Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --disable_result_log
4 select * from performance_schema.innodb_redo_log_files;
5 --enable_result_log
6
7 select * from performance_schema.innodb_redo_log_files
8 where file_name='foo';
9
10 --error ER_TABLEACCESS_DENIED_ERROR
11 insert into performance_schema.innodb_redo_log_files
12 set file_name='#ib_redo1', file_id=1, start_lsn=8192, end_lsn=10240, size_in_bytes=4096,
13 is_full='YES', consumer_level=0;
14
15 --error ER_TABLEACCESS_DENIED_ERROR
16 update performance_schema.innodb_redo_log_files
17 set file_name='#ib_redo2' where file_id=1;
18
19 --error ER_TABLEACCESS_DENIED_ERROR
20 delete from performance_schema.innodb_redo_log_files;
21
22 --error ER_TABLEACCESS_DENIED_ERROR
23 delete from performance_schema.innodb_redo_log_files
24 where file_name='#ib_redo1';
25
26 -- error ER_TABLEACCESS_DENIED_ERROR
27 LOCK TABLES performance_schema.innodb_redo_log_files READ;
28 UNLOCK TABLES;
29
30 -- error ER_TABLEACCESS_DENIED_ERROR
31 LOCK TABLES performance_schema.innodb_redo_log_files WRITE;
32 UNLOCK TABLES;
33