Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --disable_result_log
4 select * from performance_schema.file_instances limit 1;
5
6 select * from performance_schema.file_instances
7 where file_name='FOO';
8 --enable_result_log
9
10 --error ER_TABLEACCESS_DENIED_ERROR
11 insert into performance_schema.file_instances
12 set file_name='FOO', event_name='BAR', open_count=12;
13
14 --error ER_TABLEACCESS_DENIED_ERROR
15 update performance_schema.file_instances
16 set file_name='FOO';
17
18 --error ER_TABLEACCESS_DENIED_ERROR
19 delete from performance_schema.file_instances
20 where event_name like "wait/%";
21
22 --error ER_TABLEACCESS_DENIED_ERROR
23 delete from performance_schema.file_instances;
24
25 -- error ER_TABLEACCESS_DENIED_ERROR
26 LOCK TABLES performance_schema.file_instances READ;
27 UNLOCK TABLES;
28
29 -- error ER_TABLEACCESS_DENIED_ERROR
30 LOCK TABLES performance_schema.file_instances WRITE;
31 UNLOCK TABLES;
32
33 --echo ###
34 --echo ### Bug#26152751: INNODB LEAKS MEMORY, PERFORMANCE_SCHEMA FILE_INSTANCES
35 --echo ### #SQL-IB3129987-252773.IBD
36 --echo ###
37
38 CREATE DATABASE db_26152751;
39 USE db_26152751;
40
41 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%";
42
43 CREATE TABLE t_db_26152751 (a INT) ENGINE=INNODB;
44
45 --replace_regex /.*\/t_db_26152751/t_db_26152751/
46 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%";
47
48 RENAME TABLE t_db_26152751 to t_db_26152751_new;
49
50 --replace_regex /.*\/t_db_26152751/t_db_26152751/
51 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%";
52
53 RENAME TABLE t_db_26152751_new to t_db_26152751;
54
55 --replace_regex /.*\/t_db_26152751/t_db_26152751/
56 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%";
57
58 ALTER TABLE t_db_26152751 ADD COLUMN b INT;
59
60 --replace_regex /.*\/t_db_26152751/t_db_26152751/
61 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%";
62
63 DROP TABLE t_db_26152751;
64
65 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%";
66
67 DROP DATABASE db_26152751;